Forum Discussion

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 05, 2025

Excellove15 , you calculate _count as max of CreatedOn for OPENED doors.  But on screenshot you filter CreatedOn on max for any status.

If to use

VAR _count =
    CALCULATE (
        MAX ( BMSDoorStoreJoin[CreatedOn] )//,
        //BMSDoorStoreJoin[Status] = "Open"
    )

measure returns nil.

In addition, in

'BMSDoorStoreJoin'[SiteId] --> 'Site'[SiteCode]

you have whole number from one site and text field on another. Better to use the same type.

  • Excellove15's avatar
    Excellove15
    Iron Contributor
    Mar 05, 2025

    Hi SergeiBaklan Sir,

     

    Thanks for your quick response! it means a lot to me🙂

    wow! i didn't realize that sir and _count should be for any status. Now after comment of filter modifier, the calculate works like a gem sir! thanks for quick fix.

    It is my stupidity i didn't check the data model data types. Agree with you sir for use of same type. I will fix it in data flows.

    its working sir 🙂

    many thanks and hope you have a wonderful day!

    i will close this query