Average Grand Total doesn't calculate correctly

Question

Currently , i am looking for Average in Grand total but apparently ,which ever way i write Dax my Total only aggregates instead of Average.

In attached example the average that i am expecting is 0.875 for my test measure in grand total apparently , it only adds up and doesn'tr resolve the context

Here is my Dax for TEST measure

Test =
IF(
ISFILTERED('Funding Source'[Allocation]),
(Sum('Capacity Fact'[AllocationAmountin Minutes])/Sum('Date'[Is Weekday]))/480,
Sumx('Provider Capacity Fact' ,
'Capacity Fact'[AllocationAmountin Minutes]/Sum('Date'[Is Weekday])/480
))

this should be 0.88*2/2 = 0.88

parry2k · Answer

bipro-atlanta&nbsp;Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.

bipro-atlanta · Answer

sample data&nbsp;https://yvspartnersllc-my.sharepoint.com/:f:/g/personal/nsomani_yvspartners_com/EpXuQ-6J5tRAqsAxJaiKu90BxIT8BALPcr6-OxWLmSlE_A?e=7sBdj2&nbsp;Here is the one drive link as requested&nbsp;

parry2k · Answer

bipro-atlanta there is lot of data, would have been nice if you shared pbix file, unfortunately don't have time to go thru each and every sheet on shared dataset.

bipro-atlanta · Answer

I uploaded the .PBIX File on the same location&nbsp;&nbsp;The measure i played in two different format are&nbsp;&nbsp;Test&nbsp;AllocationTest&nbsp;&nbsp;Both seems to be giving different results&nbsp;&nbsp;&nbsp;https://yvspartnersllc-my.sharepoint.com/personal/nsomani_yvspartners_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fnsomani%5Fyvspartners%5Fcom%2FDocuments%2FSample%20data&nbsp;

bipro-atlanta · Answer

parry2k&nbsp; - Did you get chance to take a peak at the PBIX File ?

Forum Discussion

Average Grand Total doesn't calculate correctly

6 Replies