Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
@KVPBI1 , Use a measure
Distinctcount(Table[ID]) in a visual with Expired
or calculate(Distinctcount(Table[ID]), filter(Table, table[Expired] <>0 ))
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.
@KVPBI1 , Use a measure
Distinctcount(Table[ID]) in a visual with Expired
or calculate(Distinctcount(Table[ID]), filter(Table, table[Expired] <>0 ))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
27 | |
24 | |
22 |