Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi experts!
Is there any chance to display specific measures / values within a matrix just on the total and sub total row?
So when I drill down the matrix on a product level, the measure should display a value just on the total and sub total.
Solved! Go to Solution.
@joshua1990 , use isinscope. import to check not(isinscope(Table[Column])
if(not(isinscope(Table[Column]) ) , [Measure1], [Current Measure])
because column above in the list available for below level
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
https://xxlbi.com/blog/new-dax-function-isinscope/
@joshua1990 , use isinscope. import to check not(isinscope(Table[Column])
if(not(isinscope(Table[Column]) ) , [Measure1], [Current Measure])
because column above in the list available for below level
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
https://xxlbi.com/blog/new-dax-function-isinscope/
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |