Create conditional table (SWITCH or IF functions not working)

[Anonymous]

Hello community,

i guess, I am trying to do something quite simple, but somehow DAX is not allowing to have a conditional expression in the definition of my new tabel ("Table =").

In the code above, the green command does not work (nor does it with the IF function) but the blue code works normally.

Can anyone help me there? Thanks

[v-jingzhang]

Hi @Anonymous 

A calculated table cannot be dynamic according to users' interaction with slicers and filters in the report. It is only evaluated and populated when it's created or the whole data model is refreshed. 

I guess your purpose is to filter the second slicer (Selector of Partner) with the selected value in the first slicer (Selector of Feature). You can generate a table in below structure. Features are in one column and their related Partners are in the other column. Then you can put Feature column in the first slicer and put Partner column in the other slicer. In this way, the second slicer can be filtered. 

Hope it helps.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Anonymous , I doubt you can switch tables,  Also you can not use measure in new table creation, it will not work correctly

you can move code if inside the distinct and try 

[Anonymous]

Hello @amitchandak , sadly it didnt work.

What I am trying to do with this dynamic table, is to have a dynamic selector. I want to be able to change the column in my visual "Selector of Partner" in accordance with what my "Selector of Feature" selects.

Any ideas?