Forum Discussion

MA654654's avatar
MA654654
Regular Visitor
2 years ago

Remove interaction with slicer for specific column in Matrix

I need a solution for remove interaction with slicer for specific column in matrix table. I have a table with 5 columns from that 2 columns, I am using measure to bring data into the table. and this ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, MA654654 

Thanks for amitchandak and bhanu_gautam reply. You can try this measure.

CancelledOrders = 
CALCULATE(
    COUNTROWS(Ordertable),
    Ordertable[status] IN {"cancelled before dispatch", "cancelled during transit", ...},
    REMOVEFILTERS(Ordertable[status]),
    ALLSELECTED(Ordertable)
)

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum