Really need help in total not capturing correctly in my table

[sajjadkhan25]

Hi Team and @amitchandak sir ,

hope all are good need help with this,

following is the screen shot where you can see total is coming wrong 

A1 = [sdk]*Ac_T1[conversion],[sdk]
sdk = is the simple running total of values 

conversion =

CALCULATE(

    SUM(vwCurrencyConversion[YTD_Rate]),vwCurrencyConversion[month_yeaR_MAP]=SELECTEDVALUE(Ac_T1[FY]))
Ac_T1 is my slicer value coming from other table 

Account Desc is coming from hierarchy table 

please help me how to correct my measure to make value come properly.

Thanks in advance

[Anonymous · Accepted solution]

Hi @sajjadkhan25 ,

The total is not what you expect because the total also performs the calculation logic of your formula, rather than simply adding up the row values.

Try

new A1 = SUMX(SUMMARIZE('Table','Table'[LocalCurrency],"conversion",[conversion],"A1",[A1]),[A1])

Note: If [LocalCurrency] is a column, reference it directly, if it is a measure, do like [conversion] and [A1].

If still not correct, please provide some sample data and expected results. Then I have another question, why is there a comma after [conversion] and then [sdk]?

Fixing Incorrect Totals Using DAX Measures In Power BI | Enterprise DNA

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Please see this video on how to get the expected total value in your visual.

(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat

[sajjadkhan25]

Please help me with this