Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
please can someone help me solve this seemingly easy problem.
White , Open
White, Closed
Red, Closed
Blue, Open
Green, Closed
Green, Open
White, Closed
White, Closed
Red, Closed
White, Open
Green, Open
Green, Open
Black, Closed
Blue, Closed
Blue, Open
Red, Open
White, Closed
White, Closed
White, Open
White, Open
Of this data set. 9 are white. If I than filter on closed 5 are white. Hence 5/9 55.5% are White closed.
I want this to show in a report table.
Column headers:
Colour, Filtered Colour Count, Unfiltered Colour Count, Filtered as % of Unfiltered Colour Count.
Solved! Go to Solution.
Thanks Smoupre. That helped me figure it out.
Solution:
MyMeasure= COUNTA(Data[Colour[) / CALCULATE( COUNTA(Data[Colour]) , ALL(Data[Open/ Closed]))
You would probably be better off with a measure instead of custom columns, something like:
MyMeasure = COUNTA([Colour])/CALCULATE(COUNTA([Colour]),ALL(Table))
Then, as you filter in your report by color or status or if you put this in a matrix, the measure will calculate out correctly.
Thanks Smoupre. That helped me figure it out.
Solution:
MyMeasure= COUNTA(Data[Colour[) / CALCULATE( COUNTA(Data[Colour]) , ALL(Data[Open/ Closed]))
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |