Forum Discussion

bsz412's avatar
bsz412
Helper III
3 years ago
Solved

summarize function help DAX

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!
Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    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

1 Reply

  • DataInsights's avatar
    DataInsights
    Super User
    3 years ago

    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