Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Create conditional table (SWITCH or IF functions not working)

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 t...
Need Help
Show and Tell
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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.