Forum Discussion
Conditional Filtering
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.
Please provide example data as table(s) not a screen shot
and example output with a better description
so we can help you.
You can copy and paste table date into this forum but remeber to remove any privarte data 😀
Thank you for your swift reponse of course example data would have been helpful !! Here is a snippet of my data in tabular format. You can see the category in the first column - in Power Bi i want to condition filter the training columns with respect to its corresponding product. Hope this makes sense 🙂
Product Classification Code 1 Menswear Training Completed Sports Training Completed Kids Training Completed Sales Menswear TRUE FALSE FALSE 55 Sports FALSE TRUE FALSE 20 Kids FALSE FALSE TRUE 58 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.