Sum of average

[Anonymous]

I have a table with the average of sells per product per month, like the image. When I add the total of power bi, automatically it shows as total the average per month but I would like to see the sum of each average YTD. Like the example.

How can I do this in DAX?

Thank you in advance.

[Anonymous]

Hi,

Thanks for the replying. But unfortunately this don't solve it. 😞 I need to sum the results from each month average. Each average that I did through the sumproduct.

[Jihwan_Kim]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your dataset.

Expected result measure: =
IF ( HASONEVALUE ( Data[Date] ), AVERAGE ( Data[Qty] ), SUM ( Data[Qty] ) )