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

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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?




  • 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.