Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |