Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 ))
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |