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.
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 |
Community SupportHi 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.
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.