Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Icon for Helper IV rankHelper IV
10 years ago
Solved

Help with Dax Measure for Policy Count

DateDimensionID JobCloseDate PolicyNumber TermNumber BranchID Job MostRecentModel 1 7/1/2016 0:00 A 1 1 Submission 1 2 7/2/2016 0:00 A 1 2 Policy Change 1 2 7/2/2016 0:...
Need Help
  • Habib's avatar
    Habib
    10 years ago

    Hi vickyprudhvi,

     

    Can you please give a try to below formual to add a measure.

     

    JobCount= CALCULATE(DISTINCTCOUNT(Table1[PolicyNumber]),Table1[JobCloseDate]<=VALUES(Table1[JobCloseDate]))

    You can show this on your card visual and it will give you count of distinct policy numbers till your selected date.

vickyprudhvi's avatar
vickyprudhvi
Icon for Helper IV rankHelper IV
10 years ago

Thanks Habib this seems working

I would like to know why we give Values on LHS of the equation

Habib's avatar
Habib
Icon for Continued Contributor rankContinued Contributor
10 years ago

It gives you the value of field in current context and in your case its the selected value in Slicer.

  • vickyprudhvi's avatar
    vickyprudhvi
    Icon for Helper IV rankHelper IV
    10 years ago

    hi Habib

     

    how to count policy which has prior Job type as Reinstatement

    I am not able to firgure it out

    thnak you

    for help

    • Habib's avatar
      Habib
      Icon for Continued Contributor rankContinued Contributor
      10 years ago

      If you are looking for count of policies against specific job type, here is the syntax.

       

      PolictCountReinstatement = CALCULATE(DISTINCTCOUNT(Table1[PolicyNumber]),Table1[JobCloseDate]<=VALUES(Table1[JobCloseDate]),Table1[Job] ="Reinstatement")
      • vickyprudhvi's avatar
        vickyprudhvi
        Icon for Helper IV rankHelper IV
        10 years ago
        Habib
        I want to count policy whose previous job status is reinstatement