Formula to return a count for given criteria

[KVPBI1]

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	30
3	30
3	30

Expected Result
Expired	Count
30	2
60	1
90	1

Thanks!

[v-chenwuz-msft]

Hi @KVPBI1 ,

Or you can use the functions provided by power bi to achieve the results you want. Please refer to the gif below.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@KVPBI1 , Use a measure

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

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