Forum Discussion

JulietZhu's avatar
JulietZhu
Helper IV
7 years ago
Solved

Error when DATEDIFF use as filter

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

 

 

Need Help
  • tarunsingla's avatar
    tarunsingla
    7 years ago

    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

2 Replies

  • tarunsingla's avatar
    tarunsingla
    Solution Sage
    7 years ago

    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