DAX Query

[Anonymous]

Hi Team,

I havn't idea for how to get final value in column "H".

please help above table (i need column H).

Thanks,

Kalidass

[edhans]

You want something along the lines of this:

Final =
1
    - DIVIDE(
        SUM( 'Table'[Final Fcst] ),
        SUM( 'Table'[Actuals] ),
        0
    )

But be aware that is heavily dependent on how the model and visuals filters that. If that is in a table and you have those fields showing it will work. But if you dropped it in a table that only had the month, it will add up all records in that month and so the same math, so make sure you try it out in a few different configurations to ensure it is returning what you want. 

[amitchandak · Accepted solution]

@Anonymous , Try

New Measure = 1- divide(sum(Table[Actuals]),sum(Table[Final Fcst]))

[Anonymous]

Hi @amitchandak 

Thanks for your help.

I will close my query.

Thanks,

Kalidass

[Anonymous]

Hi @Anonymous ，

If your problem has been resolved, could you please mark the helpful post as Answered? It will help other member in the community find the solution easily when they face the same problem. Thank you.

Best Regards

Rena