Slicer filter multiple columns in a table

[Anonymous]

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!

[OwenAuger]

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

[Anonymous]

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

[amitchandak · Accepted solution]

@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/

[Anonymous]

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