Sum of Value

[Anonymous]

Hi Team,

I knew this is simple concept  but i don't know how to implement in new measures, please help me.

above file i need to calculate based on Reg LLM column for sum of (TR07+TR08+TR09).

Thanks,

KV

[Greg_Deckler · Accepted solution]

Well, as a measure it would be:

Measure = MAX([TR07]) + MAX([TR08]) + MAX([TR09])

Or you could create a calculated column in the table:

Column = [TR07] + [TR08] + [TR09]

And then just use default SUM aggregation for that new column

OR, you could unpivot those three columns in Power Query and that would probably make things much easier.

[amitchandak]

@Anonymous , put Reg LLM in the visual

and a Measure like this. it should do

sum(Table[TR07])+sum(Table[TR08])+sum(Table[TR09])

Or

sumx(Table , Table[TR07]+Table[TR08]+Table[TR09])

[Anonymous]

Hi @amitchandak ,

Thanks for your reply,

I need dax measures calculation for Reg LLM with all column (TR07 to 09)

Thanks,

KV

[amitchandak]

@Anonymous , what do mean by that.

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Hi @amitchandak ,

I have to create Icon for conditional formatting in (front) summary page, so I need this calculation value in separately.

Thanks,

KV