Forum Discussion
Solved
DAX - Total divided by rows
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
Hi,
Try this measure
=CALCULATE(SUM(Data[Tsp]),ALL(Data[Buckets]))/SUM(Data[IDCount])
Hope this helps.
1 Reply
Hi,
Try this measure
=CALCULATE(SUM(Data[Tsp]),ALL(Data[Buckets]))/SUM(Data[IDCount])
Hope this helps.