Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, this is the problem I am having right now.
I am practicing AdventureworksDW 2019.
From accounting point of view, the Total sales would be = sales amount+ tax+ freight [ you know that all costs related to sales must be added up]. so the amount we get is $17,727,276.
Now, when I calculate All Sales = CALCULATE([Total Sales], All(Sales)) - Sales is the table name here, the number should be $17,727,276. But here it's not the case. what should I do to solve this?
Solved! Go to Solution.
Hi:
If your data has sales for more than one year, using "ALL" will take filters away and give you grand total for everything. Since you are filtering on Name, is it possible that some transactions do not have a name associated with them?
You can test by putting these two measures in a separate card and comparing. [Total Sales] should equal ALL sales if no filters are applied to [Total Sales].
I hope this helps!
Thank you so much, it worked 🙂.
You are welcome.
Hi:
If your data has sales for more than one year, using "ALL" will take filters away and give you grand total for everything. Since you are filtering on Name, is it possible that some transactions do not have a name associated with them?
You can test by putting these two measures in a separate card and comparing. [Total Sales] should equal ALL sales if no filters are applied to [Total Sales].
I hope this helps!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |