Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Data is stored in below formats but I have to count at summary 2 level if units>0.
Raw data | |||
Code | Units | ||
AP50002862105 | 1 | ||
AP50002862105 | -1 | ||
AP52001160899 | 3 | ||
BI80000160943 | 6 | ||
I have to count at Code level if units>0 | |||
Code | Units | final output | |
AP50002862105 | 0 | 0 | |
AP52001160899 | 3 | 1 | |
BI80000160943 | 6 | 1 | |
2 |
Please suggest. Thanks a lots.
@Tanushree_Kapse @amitchandak @Greg
Solved! Go to Solution.
Hi @Anonymous ,
Use these measures:
First calculate the count:
Hi @Anonymous ,
Please find the Screenshot:
Thanks for reply.
I have to count >0 units not >1 units.
I have applied the logic already as you mentioned but when I check at code level it is counting where units is 0 as well . like in table 2. first code having units 0 idealy count should not happen at that row.
please check
Hi @Anonymous ,
Use these measures:
First calculate the count:
Thanks a lot Tanu,
You are super excellent. Salut you. Thank you so much for such a great support.
Always a pleasure!😊
Now I got what I was looking for.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |