Forum Discussion

mikep7521's avatar
mikep7521
Helper III
8 years ago

Formula is giving wrong answer, why?

Hello, I'm having an issue with a column formula in Power BI. I'm foused on the three columns on the right and the formula bar which represents the far right column 'MULTIPLE'. As you can see in the...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi mikep7521,

 

It seems the last three are all columns rather than measures. If so, I would suggest you try this formula below as a MEASURE.

multiple =
SUM ( Deals[Test_Sum_of_Multiple__c] )
    / SUM ( Deals[Total_Deal_Purchase_Amt__c] )

Best Regards,

Dale