Forum Discussion
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 ...
bhanu_gautam
Super User
Super UserMA654654 , I think ALL should work here
Cancelled Orders =
CALCULATE(
COUNTROWS(Ordertable),
Ordertable[status] IN {"cancelled before dispatch", "cancelled during transit", ...},
ALL(Ordertable[status])
)
ALL(Ordertable[status]) part ensures that the slicer selection on the status column does not affect the calculation of the Cancelled Orders column. This way, the Cancelled Orders column will always show the count of orders with the specified statuses, regardless of the slicer selection.
I have tried ALL function, its still interacting with slicer, I am getting correct values only if I select all status in slicer, if i select anything specific then its change