Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Distinct Sum based on Another Column

Hi,We are trying to Sum our min value column based on disticnt values from Malzeme Column.But we have additional filters that we need for our calculation. Our code is goes as follows; Min value, h...
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    It sounds like a common multiple aggregation calculate on measures formula(sum min value abased on category group), you can try to use the following measure formula if it suitable for your requirement:

    Min value, hammadde bazında =
VAR mySymbol = 'VA05-Açık Sipariş'[Hammadde / Çap]
VAR summary =
    SUMMARIZE (
        FILTER (
            ALLSELECTED ( 'VA05-Açık Sipariş' ),
            'VA05-Açık Sipariş'[Hammadde / Çap] = mySymbol
                && 'VA05-Açık Sipariş'[30 Gün önceki Tarih Bilgisi] <= TODAY ()
                && 'VA05-Açık Sipariş'[mın value] < 0
        ),
        [Malzeme],
        "_Min", MIN ( 'VA05-Açık Sipariş'[mın value] )
    )
RETURN
    SUMX ( summary, [_Min] )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

It sounds like a common multiple aggregation calculate on measures formula(sum min value abased on category group), you can try to use the following measure formula if it suitable for your requirement:

Min value, hammadde bazında =
VAR mySymbol = 'VA05-Açık Sipariş'[Hammadde / Çap]
VAR summary =
    SUMMARIZE (
        FILTER (
            ALLSELECTED ( 'VA05-Açık Sipariş' ),
            'VA05-Açık Sipariş'[Hammadde / Çap] = mySymbol
                && 'VA05-Açık Sipariş'[30 Gün önceki Tarih Bilgisi] <= TODAY ()
                && 'VA05-Açık Sipariş'[mın value] < 0
        ),
        [Malzeme],
        "_Min", MIN ( 'VA05-Açık Sipariş'[mın value] )
    )
RETURN
    SUMX ( summary, [_Min] )

Regards,

Xiaoxin Sheng