devide two columns

[Nimmi]

Hi,

I am new to power BI, devide of two columns sum is not working.

here is my measure:

Relative data = CALCULATE((SUM('dpdb fact_budget'[planned_vs_actual_amt])*100)/(SUM('dpdb fact_budget'[planned_cost_edited])))

Please help.

[v-danhe-msft · Accepted solution]

Hi @Nimmi,

Based on my test, it could work on my side:

sample data:

Result:

Could you please offer your sample data to have a test if possible?

Regards,

Daniel He

[Nimmi]

Hi @v-danhe-msft,

Yes its working fine I have added one space by mistake in my measure while creating slicer measure.

Thanks for your reply.