Division on power bi report

[Anonymous]

Hi all,

First of all thank you in advance for anyone who reply with a correct answer.

I have tried to ask this questions on several forums and i just could not find a solution so i have prepared a sample file in excel that describes what i am looking for.

On  the real power bi file i have a matrix report in which containing a column and sub column (as matrix usually display). The main column(the divisor) only contains a single value and the rest is empty and the sub column(the dividend) contains values in each row. what i want is divide values in each sub column by the single value in the main column. with the formula DIVIDE:([sub column],[main column]) brings an over all division and make the column empty. 

i dont know if i explained what i am looking for (which i always find it hard) but i think the picture will explain better than my words.

Thanks,

EDsample question with excel filethe real PBI file

[v-yulgu-msft]

Hi @Anonymous,

Maybe you need a measure similar to below:

Percentage =
SUM ( Table[value] )
    / CALCULATE ( SUM ( Table[Value] ), ALL ( Table[Subcolumn] ) )

Regards,

Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft,

Thanks for your response. 

I could do that but unfortunately both of them are measures not columns and as you know aggregation won't work when the parameters are both measures.