Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
3 years ago

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

 

 

What Measure do I need to compute what I need?

 

Need Help

5 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    3 years ago

    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's avatar
      bdehning
      Post Prodigy
      3 years ago

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

      • Ahmedx's avatar
        Ahmedx
        Super User
        3 years ago

        pls try this

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

         

  • bdehning's avatar
    bdehning
    Post Prodigy
    3 years ago

    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's avatar
      Ahmedx
      Super User
      3 years ago

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