Forum Discussion
How to use countx with multiple parameter
HI Team
i do have this below table
| Area | Case |
| Sydney | Review |
| Sydney | Accepted |
| Melbourne | Dispute |
| Melbourne | Dispute |
| Melbourne | Review |
| Perth | Accepted |
| Perth | Review |
| Sydney | Dispute |
| Perth | Dispute |
| Melbourne | Review |
i like this way in Power Bi
| K | L | M | N | O | P | Q | R |
| Row Labels | Accepted | % completed | Dispute | % completed | Review | % completed | Grand Total |
| Melbourne | L3/R3 | 2 | N3/R3 | 2 | P3/R3 | 4 | |
| Perth | 1 | L4/R4 | 1 | N4/R4 | 1 | P4/R4 | 3 |
| Sydney | 1 | L5/R5 | 1 | N5/R5 | 1 | P5/R5 | 3 |
| Grand Total | 2 | L6/R6 | 4 | 4 | 10 |
with countx function in Power Bi measure
can anyone guide me. Heaps thansk i
Anonymous
Based on the above sample data, what exactly do you need to count? Please provide the expected result.Anonymous
Create two measures: I attached the file below my signature.Count = COUNTROWS(Table1)Count % = DIVIDE( [Count], CALCULATE( [Count], ALLSELECTED(Table1[Case] ) ) )
6 Replies
Anonymous
Based on the above sample data, what exactly do you need to count? Please provide the expected result.Anonymous
Create two measures: I attached the file below my signature.Count = COUNTROWS(Table1)Count % = DIVIDE( [Count], CALCULATE( [Count], ALLSELECTED(Table1[Case] ) ) )
Anonymous
You do not need a calculation. Insert a matrix visual onto the report canvas, add the AREA to Rows section and the CASE to Column selection then insert a CASE again to the Value section and set the aggregation to COUNT