Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Easy question here (I think, as I haven't done PowerBI in a couple years and all my skills have left me):
I have a table like this
Team | Status |
Team1 | Red |
Team1 | Green |
Team2 | Red |
Team2 | Yellow |
Team2 | Red |
Team2 | Green |
My usecase is that I want to be able to count the number of rows that are of status Red, status Yellow, and status Green...and then have a separate multi-row card that shows percentage in each. It should also be able to change based on what Team is selected, so I'm guessing I need a measure.
So for example, with no filters applied, it should show 50% Red, 17% Yellow, 33% Green
If I filter to only Team2, it should show 50% Red, 25% Yellow, 25% Green
Would also be cool to have a way to show % of a certain color for each team.
Solved! Go to Solution.
pls create a status table
and create a measure
Measure = CALCULATE(COUNTROWS('Table'),'Table'[Status]=max('Table (2)'[status]))/COUNTROWS('Table')
Proud to be a Super User!
pls create a status table
and create a measure
Measure = CALCULATE(COUNTROWS('Table'),'Table'[Status]=max('Table (2)'[status]))/COUNTROWS('Table')
Proud to be a Super User!
This works, thank you!
Hi,
To show the Teamname add the below column to your table :
Accepted the other answer since I tried it first, but I'm going to also try this to see if it gives more flexibility. Never used the COALESCE command before. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |