Forum Discussion

mikep7521's avatar
mikep7521
Icon for Helper III rankHelper 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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Have you tried wrapping the formula in a CALCULATE statement?

MULTIPLE = CALCULATE( DIVIDE( Deals[Test_Sum_of_Multiple__c] , Deals[Total_Deal_Purchase_Amt__c] ) )  

mikep7521's avatar
mikep7521
Icon for Helper III rankHelper III
8 years ago

when i try this option I'm not able to reference the necessary coumns. I can only select formulas or measures after the Divide(.