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.

Habib's avatar
Habib
Continued Contributor
10 years ago

You can use DAX table to achieve this.

 

Create a new table by clicking on Modeling --> New Table adn add following formula.

 

SummaryTable = SUMMARIZE(Table1,Table1[JobCloseDate],"JobCount",DISTINCTCOUNT(Table1[PolicyNumber]))
vickyprudhvi's avatar
vickyprudhvi
Helper IV
10 years ago

Thank you Habib for ur reply

but I am not looking to create a new table and I want it to be dynamic as we click JobClosedate slicer on Power BI Desktop.