subtract the summation of two different categories from the total

[OPS-MLTSD]

Hello, I am trying to add up the data from two different categories first and then subtract the value from the total, I created this measure but it is giving me an error, if someone could please help me fix this error, that would be great. thank you:

Measure =

VAR pl = CALCULATE(

CALCULATE(

    COUNT('Table'[Client ID]),

    FILTER(‘Table’, ‘Table’[Status] = "Active"),

    FILTER(‘Table’, ‘Table’[Category] = "B" )

   ) +

CALCULATE(

    COUNT(‘Table’[Client ID]),

    FILTER(‘Table’, ‘Table’[Status] = "Active"),

    FILTER(‘Table’, ‘Table’[Category] = "C" )

   )

)

VAR tot = CALCULATE(

    COUNT(‘Table’[Client ID]),

    FILTER(‘Table’, ‘Table’[Status] = "Active"),

    FILTER(‘Table’, ‘Table’[Category] <> NULL)

   )

Return

CALCULATE(SUMX(tot))-CALCULATE(SUMX(pl))

[AlexisOlson · Accepted solution]

"<> NULL" won't work. You need to use ISBLANK instead.

Also, you don't need to write CALCULATE ( SUMX (...) ) in the final line.

Try this:

Measure1 =
VAR pl =
    CALCULATE (
        COUNT ( 'Table'[Client ID] ),
        FILTER ( 'Table', 'Table'[Status] = "Active" ),
        FILTER ( 'Table', 'Table'[Category] IN { "B", "C" } )
    )
VAR tot =
    CALCULATE (
        COUNT ( 'Table'[Client ID] ),
        FILTER ( 'Table', 'Table'[Status] = "Active" ),
        FILTER ( 'Table', NOT ISBLANK ( 'Table'[Category] ) )
    )
RETURN
    tot - pl

[OPS-MLTSD]

Thank you so much!