How to use countx with multiple parameter

[Anonymous]

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

[Fowmy · Accepted solution]

@Anonymous 

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

[Fowmy]

@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 

[Anonymous]

i am counting in excel by pivot table like this

like this

[Fowmy · Accepted solution]

@Anonymous 

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

Count = COUNTROWS(Table1)

Count % = 

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

[Anonymous]

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

[Fowmy · Accepted solution]

@Anonymous 

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

[Anonymous]

HI Fowmy, thanks for replying, 

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