bdehningPost Prodigy3 years agoCalculate a Divide I have the following table and I need to divide Count by Sum. I should for 01/01/23 for example see .4315, but I do not. Count is a Column in LossRun Table and Sum is a Decimal Number in Policy ...Show More
bdehningPost Prodigy3 years agoGot it to work, but now how do I get it to leave off the 2017 year since Sum Column is Blank?
AhmedxSuper User to bdehning3 years agopls try thisMeasure= DIVIDE(SUM(LossRun[Count]),SUM('Policy Fact Table'[Sum column]))+0
Related contentCalculating a divide for a table - what am I missing??Custom Column Divide CalculationDivide in Power BIDivide two Calculation ItemsDivide / Calculate / Countrows with filters
