Forum Discussion

Krzysztof1's avatar
Krzysztof1
Regular Visitor
2 years ago

Hiding selective rows in matrix

Hi Colleagues Colud you advise what measure should I apply to get the effect : hiding selective rows in matrix without affecting subtotals  I am preparing the report and I want to show only 1 selet...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Krzysztof1 ,

 

Maybe you can try formula like below:

Visible Sales = 
IF (
    MAX(Sales[Category]) = "SelectedCategory",
    MAX(Sales[SalesAmount]),
    BLANK()
)

Total Sales = 
SUMX (
    ALLSELECTED(Sales),
    Sales[SalesAmount]
)

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Krzysztof1's avatar
Krzysztof1
Regular Visitor
2 years ago

Many thanks 
I am still looking for another soluition
My problem is as follows

I want to show only selectedCategory in Region1 and Region2 and hide theAnotherCategory but show also orignal Sum Of SelectedCategory and Sum of Region