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 All,
I currently have the following matrix;
As you can see the 'Sum of Costs' measure can be broken down into currencies. However when we drill up to the supplier level the 'sum of costs' totals, however this value is incorrect as it is the combination of two different currencies (see below).
What I have been asked to do is Blank out the total when its drilled up to the supplier level, but have values when like above (split out by currencies).
Any ideas?
Thanks
You can use DAX "HASONEVALUE()" with an if-statement in your measure to return a different result for the total vs not total in matrices. You'd use the HASONEVALUE() check against the field in question (currency?) to check if it's aggregated or not, then just have your if-statement return blank if it's false and the actual value if it's true.
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 |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |