Forum Discussion
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...
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] ) )
when i try this option I'm not able to reference the necessary coumns. I can only select formulas or measures after the Divide(.