Measure taking too long to calculate see below measure

[Anonymous]

CALCULATE([Days Supply],FILTER(ALLEXCEPT(Factpatientdetails,Factpatientdetails[PatientId]),[#Reset2] = MAXX(Factpatientdetails,[#Reset2]))))

[Anonymous · Accepted solution]

Hi @Anonymous 

Check whether your data source has a lot of data, because a large amount of data will also cause slow calculation, and you can refer to the following measure.

Measure =
CALCULATE (
    [Days Supply],
    FILTER (
        ALLSELECTED ( Factpatientdetails ),
        [#Reset2] = MAX ( Factpatientdetails[#Reset2] )
            && [PatientId] IN VALUES ( Factpatientdetails[PatientId] )
    )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.