cancel
Showing results for
Did you mean:
Helper II

## 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

2 ACCEPTED SOLUTIONS
Super User

@vcm2778

Based on the above sample data, what exactly do you need to count? Please provide the expected result.

Did I answer your question? Mark my post as a solution! and hit thumbs up
Super User

@vcm2778

Create two measures: I attached the file below my signature.

``Count = COUNTROWS(Table1)``
``````Count % =

DIVIDE(
[Count],
CALCULATE(
[Count],
ALLSELECTED(Table1[Case] )
)
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up
6 REPLIES 6
Super User

@vcm2778

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II

i am counting in excel by pivot table like this

like this

Super User

@vcm2778

Create two measures: I attached the file below my signature.

``Count = COUNTROWS(Table1)``
``````Count % =

DIVIDE(
[Count],
CALCULATE(
[Count],
ALLSELECTED(Table1[Case] )
)
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II

Heaps thanks mate, all good. i got what i wanted. appriciate your help

Super User

@vcm2778

Based on the above sample data, what exactly do you need to count? Please provide the expected result.

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II

I am counting how many % complted every Area by case wise. like Sydney is having 4 rows then how many % for Review, Dispute....

Announcements

#### Launching new user group features

Learn how to create your own user groups today!