Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Is it possible to turn off totals for particular rows in a matrix? I want those highlighted below OFF and the rest of the totals to still show.
Solved! Go to Solution.
Hi @HenryJS
I created a sample ,maybe you can refer to it
Original data and the effect of adding a measure
You can see that the subtotal for Country=”UK” is removed .But the grand total is still kept .
Create a measure like :
Measure =
IF (
ISINSCOPE ( 'Table'[Country] ),
IF (
MAX ( 'Table'[Country] ) = "UK",
IF ( ISINSCOPE ( 'Table'[Store] ), SUM ( 'Table'[Price] ), BLANK () ),
SUM ( 'Table'[Price] )
),
SUM ( 'Table'[Price] )
)
Then use the measure replace the value in Visual Values .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @HenryJS
I created a sample ,maybe you can refer to it
Original data and the effect of adding a measure
You can see that the subtotal for Country=”UK” is removed .But the grand total is still kept .
Create a measure like :
Measure =
IF (
ISINSCOPE ( 'Table'[Country] ),
IF (
MAX ( 'Table'[Country] ) = "UK",
IF ( ISINSCOPE ( 'Table'[Store] ), SUM ( 'Table'[Price] ), BLANK () ),
SUM ( 'Table'[Price] )
),
SUM ( 'Table'[Price] )
)
Then use the measure replace the value in Visual Values .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@HenryJS , You can make them blank based on condition
using isfiltered or isinscope https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |