Forum Discussion

KVPBI1's avatar
KVPBI1
New Member
4 years ago
Solved

Formula to return a count for given criteria

I have a dataset that includes multiple IDs and expiration buckets. Each ID should only have one count per bucket.   Dataset   ID Expired 1 30 1 0 1 30 2 60 2 90 3 3...
  • amitchandak's avatar
    amitchandak
    4 years ago

    KVPBI1 , Use a measure

     

    Distinctcount(Table[ID]) in a visual with Expired

     

    or calculate(Distinctcount(Table[ID]), filter(Table, table[Expired] <>0 ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

KVPBI1 , Use a measure

 

Distinctcount(Table[ID]) in a visual with Expired

 

or calculate(Distinctcount(Table[ID]), filter(Table, table[Expired] <>0 ))