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.

  • Fowmy's avatar
    Fowmy
    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] )
    )
)

     

    How to use countx with multiple parameter.pbix16 KB
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] )
    )
)

     

    How to use countx with multiple parameter.pbix16 KB
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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