Total not what I need it to be

[KaylaJV]

Hi All, 

I have a very complicated dashboard I have taken over from someone and I am still new to PowerBI 

The total below should show $49,197,123.91 which the rows equal to. How can I change it so this happens. 

[Anonymous · Accepted solution]

Hi @KaylaJV ,

Create another measure like below and use it in visual instead.

measure =
IF (
    ISINSCOPE ( Table[No & Name] ),
    [actual],
    SUMX ( VALUES ( Table[No & Name] ), [actual] )
)

Best Regards,

Jay

[amitchandak]

@KaylaJV ,Change Return

Return

Sumx(Values(Table[No & Name]),z)

Also, check

https://www.youtube.com/watch?v=ufHOOLdi_jk

[KaylaJV]

Doesnt seem to work. 

[amitchandak]

@KaylaJV , All you column used in matrix

Sumx(Summarize(Table[No & Name], Table[Col1], Table[Col2]),Calculate(z) )

Sumx(Addcolumns(Summarize(Table[No & Name], Table[Col1], Table[Col2]), "_1",Calculate(z) ), [_1])