Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Filtering

Hi there,   This is my first time asking a question on the forum so forgive any novicey language and/or ignorance.   Is it possible to action a filter based off another column filter ? Essentiall...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    1 unpivot the column and let the table looks like this:

    2 create a measure and put it in the values of martix table.

    Measure = IF(SELECTEDVALUE('Table'[Value])="FALSE",BLANK(),SUM('Table'[Sales ]))
    Result:


    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

I like your suggestion v-chenwuz-msft 👍