Calculated Measure based on Month

[Sonal27]

I have a Opening Count Measure (Given Below). The Logic which I have applied is:

If you looking for the Opening Count for Jan-2017 then Merge1[Loggd_dt] should be before 01 Jan 2017 and Merge1[Cmplt_dt] values should be from 01 jan 2017 (The data is from year 2005 upto date and the logic is to be applied to overall data). I am taking this measure in a matrix(along with two other measures). I have also applied some slicer in the same page. My other two measures are changing according to the value selected in Slicer. But the measure given below is not changing according to slicer.

Opening Count = 
IF (
    HASONEVALUE ( DateTable[StartOfMonthDate] ),
    CALCULATE (
        [Count_rows],
        FILTER (
            ALL ( Merge1 ),
            (
                Merge1[LOGGD_DT]
                    < CALCULATE (
                        VALUES ( DateTable[StartOfMonthDate] ),
                        USERELATIONSHIP ( DateTable[Date], Merge1[LOGGD_DT] )
                    )
                    && Merge1[CMPLT_DT]
                        >= CALCULATE (
                            VALUES ( DateTable[StartOfMonthDate] ),
                            USERELATIONSHIP ( DateTable[Date], Merge1[CMPLT_DT] )
                        )
            )
        )
    )
)

Closed Count = 
CALCULATE (
    [Count_rows],
    USERELATIONSHIP ( DateTable[Date], Merge1[CMPLT_DT] ),
    Merge1[STATUS] = "CL"
)

InProcess Count = 
CALCULATE (
    [Count_rows],
    USERELATIONSHIP ( DateTable[Date], Merge1[LOGGD_DT] )
    )

Count_rows = COUNTROWS(Merge1)

Please help me with the same. 

[v-yulgu-msft · Accepted solution]

Hi @Sonal27,

Please replace ALL with ALLSELECTED in measure [opening Count].

Opening Count = 
IF (
    HASONEVALUE ( DateTable[StartOfMonthDate] ),
    CALCULATE (
        [Count_rows],
        FILTER (
            ALLSELECTED ( Merge1 ),
            (
                Merge1[LOGGD_DT]
                    < CALCULATE (
                        VALUES ( DateTable[StartOfMonthDate] ),
                        USERELATIONSHIP ( DateTable[Date], Merge1[LOGGD_DT] )
                    )
                    && Merge1[CMPLT_DT]
                        >= CALCULATE (
                            VALUES ( DateTable[StartOfMonthDate] ),
                            USERELATIONSHIP ( DateTable[Date], Merge1[CMPLT_DT] )
                        )
            )
        )
    )
)

Best regards,

Yuliana Gu