Forum Discussion

raviteja1994's avatar
raviteja1994
Regular Visitor
8 years ago
Solved

DAX Create measure with multiple aggregations over 2 columns

Hello,   I am trying to create a DAX measure with following table.   Column A Column B Column C Date Value 1 1 P1 10/26/2017 10 1 1 P1 10/27/2017 20 1 3 P3 10/28/2017 ...
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    raviteja1994

    You can try

    sum =
VAR first_agg_tbl =
    SUMMARIZE (
        yourTable,
        yourTable[Column C],
        "Max of each column C", MAX ( yourTable[Value] )
    )
RETURN
    SUMX ( first_agg_tbl, [Max of each column C] )

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago

raviteja1994

You can try

sum =
VAR first_agg_tbl =
    SUMMARIZE (
        yourTable,
        yourTable[Column C],
        "Max of each column C", MAX ( yourTable[Value] )
    )
RETURN
    SUMX ( first_agg_tbl, [Max of each column C] )

  • raviteja1994's avatar
    raviteja1994
    Regular Visitor
    8 years ago

    Thank you Eric. It was working great..