Grand Total on Annualized Value

[PowerBIUser349]

Hey Everyone, 

I could use some help with the total column on an annulized value. Here is my data: 

Department	Value	MonthCount	Annualized Value
A	40,000	12	40,000
B	30,000	12	30,000
C	5,600	10	6,720
D	4,000	8	6,000
Incorrect Total	79,600	42	22,743
Correct Total	79,600	42	82,720

You will see that I've added two Total lines. One that is incorrect and this is what my current dax is returning. I need my dax to return the "Correct Total" line. Here is my current dax:

• _Value = SUM('Table'[Value])
• _MonthCount = SUM('Table'[MonthCount])

• _Annualized_Value = DIVIDE([_Value],[_MonthCount])*12

You will notice that I need the annualized value to sum all the departments rather than apply the same calculation.

*Edit: I should have also clarified that this is a sample of my data model. My data model won't return the correct values if I make this a calculated column. Whereas, this sample will return the correct totals if you sum the calculated column. 

Any Ideas? Thank you!

[gmsamborn]

Hi @PowerBIUser349 

Does this help as a measure?

AV = 
    SUMX(
        'Table',
        DIVIDE( 'Table'[Value], 'Table'[MonthCount] ) * 12
    )

[Ashish_Mathur]

Hi,

Drag this measure to the visual

Correct annualised value = SUMX(VALUES(Table[Department]),[_annualized_value])

Hope this helps.

[marcelsmaglhaes]

@PowerBIUser349 ,

You need create a Calculate Column in your table and the use this column in your annualized measure.