Multiply measure 1 with total sum of measure 2

[Anonymous]

Hi All,

I am new to PowerBi and seek one aid for a scenario.

I have scenario where I have Measure 1 - Percentage and Measure 2 - Count. These are reported monthwise. I need a third measure to multiply each percentage value with total sum of Measure 2 - Count. Eg. Jan = 8.88 * 7345, Feb = 8.40 * 7345 like wise. Need your help in this. Thanks in advance

[v-yuta-msft]

@Anonymous,

I'm afraid you should convert measure1 to a calculate column. If you still can solve it, could you please share some sample data(original data)?

Community Support Team _ Jimmy Tao

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

[Greg_Deckler]

You could use SUMMARIZE, ADDCOLUMNS or SUMMARIZECOLUMNS for this, such as:

Measure 3 = 
VAR __table = ADDCOLUMNS('Table',"__Measure2",[Percentage]*([Measure2]-[Count]))
RETURN
SUMX(__table,[__Measure2])

[Anonymous]

Hi @Greg_Deckler,

Thanks a lot for the reply.

Have a doubt. What I should replace Measure2 with ? This gives an error.

Measure 3 = 
VAR __table = ADDCOLUMNS('Table',"__Measure2",[Percentage]*([Measure2]-[Count]))
RETURN
SUMX(__table,[__Measure2])

[Greg_Deckler]

Whatever your Measure 2 is called, [Measure 2]?