Forum Discussion
POWER BI visualizations - multiple columns with different status in same report
Hello @Saxon10 ,
Is the second screenshot the result of your desire?
If yes, we suggest that you create a new status table and seven measures. See the following steps.
1. Create a table with Enter Data.
2. Create seven measures and place them in a table visual.
STATUS1 Measure = CALCULATE(DISTINCTCOUNT(DATA[ITEM]),FILTER(DATA,DATA[STATUS1]=MAX('Table'[State])))+0If you don't meet your requirements, could you show the exact expected result based on the table you shared?
Best regards
Community support team _ zhenbw
If this post helps,then consider Accepting it as the solution to help other members find it faster.
BTW, pbix as an attachment.
Hello @Saxon10 ,
Is the second screenshot the result of your desire?
If yes, we suggest that you create a new status table and seven measures. See the following steps.
1. Create a table with Enter Data.
2. Create seven measures and place them in a table visual.
STATUS1 Measure =
CALCULATE(DISTINCTCOUNT(DATA[ITEM]),FILTER(DATA,DATA[STATUS1]=MAX('Table'[State])))+0
If you don't meet your requirements, could you show the exact expected result based on the table you shared?
Best regards
Community support team _ zhenbw
If this post helps,then consider Accepting it as the solution to help other members find it faster.
BTW, pbix as an attachment.
This solution worked except for status values containing space characters.
In fact, it works on a small data sample but fails on large data feed.
Any suggestions?