Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count based on column

Hi All,   I want to count the number of distinct records based on the category column. This is the calculation I have done  Measure = CALCULATE( DISTINCTCOUNT(Table1[Category]), ALLEXCEPT(Ta...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , To me this seem count

     

    count(Table1[Category])

     

     

    There is not distinct value column I can see here, if there is one you can try like

    Measure =
    Sumx(Values(Table1[Category]), calculate(
    DISTINCTCOUNT(Table1[ID]))
    )

  • Samarth_18's avatar
    Samarth_18
    5 years ago

    Hi Anonymous 

     

    As you mentioned you want to display all value in cards. Since you have multiple categories so you have to use multi-row card visual.

    Under that visual you can directly drag your category and take a count of it.

    PFA screenshot for reference:-

     

    Thanks

Samarth_18's avatar
Samarth_18
Community Champion
5 years ago

Hi Anonymous 

 

As you mentioned you want to display all value in cards. Since you have multiple categories so you have to use multi-row card visual.

Under that visual you can directly drag your category and take a count of it.

PFA screenshot for reference:-

 

Thanks