Forum Discussion
Calculate 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 ...
All the +0 did was show 0.00 but left other colukn rolls blank. Is there a way to not have it show the 2017 at all?
To make my measure work I actually used
= DIVIDE(Count(LossRun[Total Gross Incurred]), Sum('Policy Fact'[Payroll by Mil]))
you need to rewrite COUNT measure like this
_Count= IF( Sum ( 'Policy Fact' [Payroll by Mil] ), Count ( LossRun [Total Gross Incurred] )) ----- = DIVIDE(_Count, Sum('Policy Fact'[Payroll by Mil]))
