summarize function help DAX

[bsz412]

Hi, 

I have the following calculated column: 

Green Class A =

CALCULATE(

COUNTX(

SUMMARIZE('product', 'product'[country_code],'product'[ETIM Class],'product'[identifier]),'product'[identifier]

),

ALLEXCEPT('product','product'[country_code],'product'[ETIM Class])

)

from product table it calculates the number of identifiers per country and etim class. 

What I would like to add to this DAX, is that this summarize table should summarize only those values where in a "Green Class" column in product table the value is "A". 

how can I add that?

thanks!

[DataInsights · Accepted solution]

@bsz412,

Try this calculated column:

Green Class A =
VAR vTable =
    CALCULATETABLE (
        SUMMARIZE (
            'product',
            'product'[country_code],
            'product'[ETIM Class],
            'product'[identifier]
        ),
        ALL ( 'product' ),
        'product'[Green Class] = "A"
    )
VAR vResult =
    CALCULATE (
        COUNTX ( vTable, 'product'[identifier] ),
        ALLEXCEPT ( 'product', 'product'[country_code], 'product'[ETIM Class] )
    )
RETURN
    vResult