topic Re: Slicer filter multiple columns in a table in DAX Commands and Tips

Slicer filter multiple columns in a table

Anonymous — Tue, 14 Dec 2021 01:50:20 GMT

I have created a Slicer to control/filter a table.

i have a table like below, and i use column Measure in the slicer

then i created a measure like below, and i use this measure in the table visual. but it only filter one column at a time. how do i change the dax in order to enable the multiple filter.

Slicer selection =

VAR MySelection =

SELECTEDVALUE('Disconnect table'[Measure], 'RDS_FL_FILE'[Total_ep])

RETUrn

SWITCH(

TRUE(),

MySelection = "Total EP", [Total_ep],

MySelection = "%EP", [%EP],

MySelection = "Total ECY", [Total_ecy],

MySelection = "%ECY", [%ECY],

[Total_ep])

as you can see, two values were selected in the slicer, but the table only shows one column. how do i edit the dax to enable multiple value return? Thank you!

Re: Slicer filter multiple columns in a table

amitchandak — Tue, 14 Dec 2021 03:31:44 GMT

Anonymous , That is possible using calculation groups, you need external tool for that
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

Re: Slicer filter multiple columns in a table

OwenAuger — Tue, 14 Dec 2021 03:33:30 GMT

Hi Anonymous

If you want to see a similar layout but with a column for each "Measure" selected, I would suggest you switch to a Matrix visual, and place "Measure" in the Columns field well.

Does that work?

Regards,

Owen

Re: Slicer filter multiple columns in a table

Anonymous — Tue, 14 Dec 2021 19:17:05 GMT

Unfortunately switching to matrix didn't work. I think the DAX needs work, SELECTEDVALUE only return one value, but I don't know how.

Re: Slicer filter multiple columns in a table

Anonymous — Tue, 14 Dec 2021 19:18:13 GMT

Thank you. I'll look into it and see if it fits what I try to accomplish.