topic Re: Formula to return a count for given criteria in DAX Commands and Tips

Formula to return a count for given criteria

KVPBI1 — Fri, 30 Sep 2022 19:42:10 GMT

I have a dataset that includes multiple IDs and expiration buckets. Each ID should only have one count per bucket.

Thanks!

amitchandak — Sat, 01 Oct 2022 02:23:19 GMT

KVPBI1 , Use a measure

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

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

v-chenwuz-msft — Mon, 03 Oct 2022 08:06:03 GMT

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.