Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Is it possible to divide the total Tsp by each ID Count. Such as:
This will need to be done in DAX. Basically I need to keep all other filters apart for the buckets on the left (periodDays).
Thanks,
Bob
Solved! Go to Solution.
Hi,
Try this measure
=CALCULATE(SUM(Data[Tsp]),ALL(Data[Buckets]))/SUM(Data[IDCount])
Hope this helps.
Hi,
Try this measure
=CALCULATE(SUM(Data[Tsp]),ALL(Data[Buckets]))/SUM(Data[IDCount])
Hope this helps.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
106 | |
93 | |
69 |
User | Count |
---|---|
167 | |
132 | |
130 | |
96 | |
91 |