Taking the total of a column and assigning that to a row in the same column | Need DAX help

[Anonymous]

How can  I take the sum/total of a measure and assign that to another row in that same column?

Let me explain...

Let's say I  have a table with Ranks/Categories such as:

RANKS

IMP0

IMP1

IMP2

IMP3

IMP4

IMP5

I have a measure which has values for IMP1-IMP5. I want the TOTAL of IMP1-5 to be put into IMP0.

RANKS	IMPRESSIONS
IMP0
IMP1	50
IMP2	100
IMP3	150
IMP4	50
IMP5	50
TOTAL	400

END RESULT

RANKS	IMPRESSIONS
IMP0	400
IMP1	50
IMP2	100
IMP3	150
IMP4	50
IMP5	50
TOTAL	400

the sum of imp1-5 is 400 so 400 is placed within IMP0.

Is this achievable?

[V-pazhen-msft]

@Anonymous 

I guess this is what you want: 

Measure = IF(max('Table'[RANKS]) ="IMP0", SUMX(ALL('Table'),[IMPRESSIONS]),[IMPRESSIONS])

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Try like

if(max(Table[IMP0]) ="IMP0", calculate(sum(Table[IMPRESSIONS]), filter(all(Table), Table[IMP0] <> "IMP0")) ,sum(Table[IMPRESSIONS]) )