Forum Discussion
Filter table based on another column value
Hello, I have a time slicer and I want to apply my filter to the table based on category. For example: I have categories Active, Complete, Teminated I want to show all the Active and Complete...
akashpasumarthi , Created with two values Terminated and All, and then use that as the slicer
Switch(selectedvalue(Slicer[value]) ,
"All", calculate(sum(Table[Value]), filter(Table, Table[Status] in {"Active", "Completed"}) ),
calculate(sum(Table[Value]), filter(Table, Table[Status] in {"Terminated"}) )
)