topic How this DAX function works. Please someone explain this, I am not able to understang it in DAX Commands and Tips

How this DAX function works. Please someone explain this, I am not able to understang it

Anonymous — Sun, 01 Jan 2023 14:11:17 GMT

Total Products with Regions =

CALCULATE(

[Total Products],

Sales)

//Used to work out how many customers sold to within each regions

Re: How this DAX function works. Please someone explain this, I am not able to understang it

tamerj1 — Sun, 01 Jan 2023 14:30:49 GMT

Hi Anonymous

I've never used this method before (placing the fact table in the CALCULATE filter when calculating a measure related to dimension table) but I noticed that many people do that and it works. It seems that when doing that the engine intersects the product keys in your case from the product table with the product keys from the sales table which is filtered by country/region from the country table. Usually I would make the code more meaningful by CROSSFILTER the relationship between Sales and Products to BOTH. That would work as well. Country filters Sales and Sales cossfilters Products.

Re: How this DAX function works. Please someone explain this, I am not able to understang it

tamerj1 — Sun, 01 Jan 2023 15:49:31 GMT

Anonymous

You can also SUMMARIZE the Sales table (which is already filtered by County) by 'Product'[Product Key]. That would provide the best performance among all the three options.

Re: How this DAX function works. Please someone explain this, I am not able to understang it

ppm1 — Sun, 01 Jan 2023 15:58:10 GMT

This pattern leverages the Expanded Table behavior of DAX. Your products table is part of the expanded Sales table. You can read more about Expanded Table here.

Expanded tables in DAX - SQLBI

Pat