Forum Discussion

Nimmi's avatar
Nimmi
Frequent Visitor
7 years ago
Solved

devide two columns

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...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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's avatar
Nimmi
Frequent Visitor
7 years ago

Hi @,

 

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

Thanks for your reply.