Error when DATEDIFF use as filter

[JulietZhu]

I have claim lag calucaited based on datediff between enc_date and final_bill_date.  After  I calculate claim lag, I need count total records for each claim lag range. Below is screenshot for 2 to 7 days. Somebody can point me where I need correct DAX. Thanks

Here is the pbix link:  https://1drv.ms/u/s!AlYpYKwSuOKxhGDMTKS188iuqNhu

[tarunsingla · Accepted solution]

Minor fix in the measure:

ClaimLag_2-7Days = CALCULATE(COUNT(EncounterCount[ClaimLag]),filter(EncounterCount, EncounterCount[ClaimLag]>=1 && EncounterCount[ClaimLag]<=7))

You need to use &&.

Regards,

Tarun

[JulietZhu]

@tarunsingla , thanks for your reply.