Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add extra Filter measure

Hello, I have a table called "IT Risk List" On that Table I'm using the following Measure: msRISK-Backlog = var em = ENDOFMONTH(Dates[Date]) var f = filter(all('IT Risk List'),'IT Risk List'[Crea...
DAX
Help me
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    please try

    msRISK-Backlog =
VAR em =
    ENDOFMONTH ( Dates[Date] )
VAR f =
    FILTER (
        ALL ( 'IT Risk List' ),
        'IT Risk List'[Created] <= em
            && NOT ( 'IT Risk List'[status] IN { "Annual Audit", "Closed" } )
    )
VAR g =
    FILTER (
        ALL ( 'IT Risk List' ),
        COALESCE ( 'IT Risk List'[Date Closed], em + 1 ) <= em
            && NOT ( 'IT Risk List'[status] IN { "Annual Audit", "Closed" } )
    )
RETURN
    COUNTROWS ( f ) - COUNTROWS ( g )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

please try

msRISK-Backlog =
VAR em =
    ENDOFMONTH ( Dates[Date] )
VAR f =
    FILTER (
        ALL ( 'IT Risk List' ),
        'IT Risk List'[Created] <= em
            && NOT ( 'IT Risk List'[status] IN { "Annual Audit", "Closed" } )
    )
VAR g =
    FILTER (
        ALL ( 'IT Risk List' ),
        COALESCE ( 'IT Risk List'[Date Closed], em + 1 ) <= em
            && NOT ( 'IT Risk List'[status] IN { "Annual Audit", "Closed" } )
    )
RETURN
    COUNTROWS ( f ) - COUNTROWS ( g )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Tamerj1,

     

    Super, you helped me out.

    Maybe easy for you but I could not create/understand it.

    Thanks again, this works perfectly.

     

    Emoes