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.
I am new to Power BI. I have created a simple matrix that looks like this:
Location | Active | Active | Non-Active | Non-Active | Total | Total |
Name | Count | % Total | Count | % Total | Count | % Total |
California | 66 | 46% | 76 | 54% | 142 | 100% |
Virginia | 98 | 81% | 23 | 19% | 121 | 100% |
Maryland | 76 | 44% | 98 | 56% | 174 | 100% |
Oregon | 34 | 50% | 34 | 50% | 68 | 100% |
Nebraska | 97 | 75% | 32 | 25% | 129 | 100% |
Nevada | 12 | 12% | 88 | 88% | 100 | 100% |
Total | 383 | 52% | 351 | 48% | 734 | 100% |
I received a request to hide some of the columns so that the resulting matrix will look something like this:
Location | Active | Total |
Name | % Total | Count |
California | 46% | 142 |
Virginia | 81% | 121 |
Maryland | 44% | 174 |
Oregon | 50% | 68 |
Nebraska | 75% | 129 |
Nevada | 12% | 100 |
Total | 52% | 734 |
How can this be accomplished? Thank you.
Solved! Go to Solution.
Remove field from Columns and add measures below to Values.
Measure = DIVIDE ( COUNTROWS ( FILTER ( 'Table', 'Table'[Status] = "Active" ) ), COUNTROWS ( 'Table' ) )
Measure 2 = COUNTROWS ( 'Table' )
Hi @AnnaBanana ,
You gave go thru this post, similar is already solved.
May be it is helpful.
Thanks,
Tejaswi
I looked at it. It is not exactly what I need. How would I display Active % Total as a percentage and Total Count as a count?
Remove field from Columns and add measures below to Values.
Measure = DIVIDE ( COUNTROWS ( FILTER ( 'Table', 'Table'[Status] = "Active" ) ), COUNTROWS ( 'Table' ) )
Measure 2 = COUNTROWS ( 'Table' )
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |