Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

i am counting in excel by pivot table like this

 

like this

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

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

Count = COUNTROWS(Table1)
Count % = 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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