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 (pe...
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.