DAX - Total divided by rows

[VendettaBob]

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

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=CALCULATE(SUM(Data[Tsp]),ALL(Data[Buckets]))/SUM(Data[IDCount])

Hope this helps.