Filter between Dimension Tables | CALCULATE function Trick!

very nice and straightforward! thank you!

Hi Chandeep. I am still not able to understand how the DAX formula works. How are the duplicates not accounted for in the correct formula?

Can I just set all the relationships in both directions in the diagram view? Is it a good idea? Its working fine

Excellent!

So using the obvious/easiest/shortcut....set relation crossfilter to both and a filter on the fact table, filters all the dimensions that are also set both.

Good One.
The trick here is even though you filter by entire sales table DAX engine internally convert this only for filter by customer key in sales table which filters by unique customers.

Great why don’t you start Crete a Wtsup group for direct interaction

just what i was looking for, thanks!

SHIT you kidding! how this was never mentioned in any documentation!
thanks a lot!

Please show us how fact table filters dim table in background

The concept behind this is expanded table...

hi, awsome technique which is still i still never read even in books. one thing i want to ask is this measure show values after applying RLS?

From where you get the data.?
Please share the link

well done, well explained, thanks!

Thanks a lot Sir....... But you explain very fast...

Excellent.

How do you display all rows side by side in a matrix visual without using Index column?

Great video!

Perfect video! but in case if you would like to know - the way you pronounce Year word in English language actually means body part (parts that listen ear) just decided to say it in order to help you improve

I just had one doubt
With your total sales correct measure
After the filter context is applied won't the sales table still have duplicate customer keys ?
Because in dax studio you used values to remove the duplicates
So how is measure functioning correctly then ?