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.
hi!
I want to build a DAX measure that calculate % of the total quantity
in this report, I have slicers of date, territory, and product category(will be single select).
every time I pick one category I want to get the percent from total:
for example, if I pick CSD I want to get 85% - 2.2M / 2.6 M
important thing- I want that the date slicer will affect the measure, but if I pick another territory I want that the answer won't change.
model looks like :
It changes because the nominator changes too.
that shall be your nominator
I need to get the total sales that only the date slicer will affect about this measure, I can't dit interactions to none because it's part od another measure that need use with the other slicers
Fine, have you tried to change the nominator as suggested?
If we break it down into factors, then I calculate the denominator in the following way:
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 |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
69 | |
47 | |
46 | |
20 | |
16 |