topic Re: Average Grand Total doesn't calculate correctly in DAX Commands and Tips

Average Grand Total doesn't calculate correctly

bipro-atlanta — Wed, 05 Jun 2019 15:57:30 GMT

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
))

Re: Average Grand Total doesn't calculate correctly

parry2k — Wed, 05 Jun 2019 16:15:47 GMT

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

Re: Average Grand Total doesn't calculate correctly

bipro-atlanta — Wed, 05 Jun 2019 17:24:37 GMT

sample data

https://yvspartnersllc-my.sharepoint.com/:f:/g/personal/nsomani_yvspartners_com/EpXuQ-6J5tRAqsAxJaiKu90BxIT8BALPcr6-OxWLmSlE_A?e=7sBdj2

Here is the one drive link as requested

Re: Average Grand Total doesn't calculate correctly

parry2k — Wed, 05 Jun 2019 17:41:26 GMT

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.

Re: Average Grand Total doesn't calculate correctly

bipro-atlanta — Wed, 05 Jun 2019 22:15:53 GMT

I uploaded the .PBIX File on the same location

The measure i played in two different format are

Test

AllocationTest

Both seems to be giving different results

https://yvspartnersllc-my.sharepoint.com/personal/nsomani_yvspartners_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fnsomani%5Fyvspartners%5Fcom%2FDocuments%2FSample%20data

Re: Average Grand Total doesn't calculate correctly

bipro-atlanta — Fri, 07 Jun 2019 18:38:27 GMT

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

Re: Average Grand Total doesn't calculate correctly

parry2k — Sat, 08 Jun 2019 16:21:54 GMT

bipro-atlanta hey I will look at this later today, bit busy for last few days. sorry for the delay.