cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Re: Help with Dax Measure for Policy Count

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 Established Member
Established Member

Re: Help with Dax Measure for Policy Count

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

Re: Help with Dax Measure for Policy Count

@Habib
I want to count policy whose previous job status is reinstatement
Habib Established Member
Established Member

Re: Help with Dax Measure for Policy Count

What will be sorting order? If date, you can have multiple policies within same date. To find context to previous value we need to sure about the data sorting order.

Re: Help with Dax Measure for Policy Count

@Habib
I guess sorting Order ll be policies

Re: Help with Dax Measure for Policy Count

@Habib

lets say the order of sorting would be Primary jy which is an identity column(1,1)