topic Re: How to sum data by year of Measure in DAX Commands and Tips

How to sum data by year of Measure

locle90 — Fri, 06 Oct 2023 04:19:07 GMT

Dear All,

I have created the Measure with average data = sum ( value ) / Sum ( qty ) by month or by item.

I want to SUM data of average by month when i select year at the yellow color. How can i do that ? Please give me your advice.

Thanks in advance.

Re: How to sum data by year of Measure

ChiragGarg2512 — Fri, 06 Oct 2023 04:51:17 GMT

locle90 , If there is a measure that gives average correctly putting it in a table visual with month should give a total value at the bottom row. If the requirement is to get sum of average in a card visual the dax will be different.

Re: How to sum data by year of Measure

locle90 — Mon, 09 Oct 2023 08:17:04 GMT

Dear @ChiragGarg2512

The table is one of the options. But how we can do that if we need to show on the card ?

Thanks

Re: How to sum data by year of Measure

Anonymous — Fri, 20 Oct 2023 09:09:06 GMT

Hi locle90 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

Total = VAR _tab = SUMMARIZE ( 'Table', 'Table'[Date], "@avg", DIVIDE ( SUM ( 'Table'[value] ), SUM ( 'Table'[qty] ) ) ) RETURN SUMX ( _tab, [@avg] )

Best Regards