Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Helper 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.

donsvensen's avatar
donsvensen
Skilled Sharer
10 years ago

Then I might have misunderstood your datamodel..

 

my example

 

 

Is the other columns in your dataset also relevant for your calculation ? - some sort of inventory calculation ?

 

br

erik

Habib's avatar
Habib
Continued Contributor
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
    Helper IV
    10 years ago

    Thanks Habib this seems working

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

  • vickyprudhvi's avatar
    vickyprudhvi
    Helper 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
      Continued 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
        Helper 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