Count of measure in a card

[KAZ]

Hi,

I am having diffuclty with the count of occupacy.  My table is now showing the correct value after using both measures below. WHen I use the same measure in a card view it has a differnt value which is not correct.  

Any help would be much appreciated. 

Thank you 😊

Measures are as follows:

Occupancy5 = VAR EndDatePerVisual = MAX('Dates'[Date]) VAR StartDatePerVisual = Min('Dates'[Date]) VAR RESULT = CALCULATE([Number of rooms checked in], REMOVEFILTERS('DATES'), Reservations[DateArrive] <= EndDatePerVisual, Reservations[DateDepart] > StartDatePerVisual || ISBLANK(Reservations[DateDepart]) ) RETURN RESULT

Count of Ocp = SUMX(ADDCOLUMNS(SUMMARIZE('Dates', 'Dates'[Date]), "@Recall", [Occupancy5]), [@Recall])

[amitchandak]

@KAZ , Assume you have active join between Arrival date and date of date table

and change the measure like and try

Occupancy5 =
VAR EndDatePerVisual =
    MAX ( 'Dates'[Date] )
VAR StartDatePerVisual =
    MIN ( 'Dates'[Date] )
VAR RESULT =
    calculate(Sumx (filter( Reservations
        Reservations[DateArrive] <= EndDatePerVisual,
        (Reservations[DateDepart] > StartDatePerVisual
            || ISBLANK ( Reservations[DateDepart] ))
    ),
        [Number of rooms checked in]), crossfilter( 'Dates'[Date],Reservations[DateArrive] , none))
        
RETURN
    RESULT