Calculate a Divide

[bdehning]

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 Fact Table.  

What Measure do I need to compute what I need?

[bdehning]

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]))

[Ahmedx]

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]))

[VahidDM]

Hi @bdehning 

Try this:
Measure= DIVIDE(SUM(LossRun[Count]),SUM('Policy Fact Table'[Sum column]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[bdehning]

Got it to work, but now how do I get it to leave off the 2017 year since Sum Column is Blank? 

[Ahmedx]

pls try this

Measure= DIVIDE(SUM(LossRun[Count]),SUM('Policy Fact Table'[Sum column]))+0