How to sum data by year of Measure

[locle90]

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.

[Anonymous · Accepted solution]

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

[ChiragGarg2512]

@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.

[locle90]

Dear @ChiragGarg2512

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

Thanks