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.