Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help please! Average Computation

Hi,   I need to average the rental net by month year selected. I am not getting an error but the average does not compute the way I want it to show.   Here is the table: The way dax comput...
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    4 years ago

    Hi Anonymous ,

     

    Measures are based in context so in this case the calculation that you have is making the total has you refer, for this you need to make us of an iterator the AVERAGEX for the total line.

     

    Try the following formula:

    Average Total = IF(
HASONEVALUE(Table[Month Year]),
[Average_Measure],
AVERAGEX(VALUES(Table[Month Year]), [Average Measure])
)

    Be aware that this may need some adjustment since I don't have any specifications about your model.

     

    If this does not work can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

MFelix's avatar
MFelix
Super User
4 years ago

Hi Anonymous ,

 

Measures are based in context so in this case the calculation that you have is making the total has you refer, for this you need to make us of an iterator the AVERAGEX for the total line.

 

Try the following formula:

Average Total = IF(
HASONEVALUE(Table[Month Year]),
[Average_Measure],
AVERAGEX(VALUES(Table[Month Year]), [Average Measure])
)

Be aware that this may need some adjustment since I don't have any specifications about your model.

 

If this does not work can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.