Forum Discussion

Sonal27's avatar
Sonal27
Regular Visitor
7 years ago
Solved

Calculated Measure based on Month

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[Cm...
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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