Forum Discussion

harrinho's avatar
harrinho
Helper III
8 years ago
Solved

ALLEXCEPT Error - Wrong use?

Hi Everyone,    I've gone thorugh similar posts but couldn't resolve my issue. I want to create a new column with the following statement:    MAX Split BU 2 = IF((CDL_SVCS_Proj_Practice_Prod_Spli...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    harrinho

     

    Try this Column

     

    Max Split BU 2 =
VAR myMax =
    CALCULATE (
        MAX ( TableName[Product Split %] ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[Project ID] ),
            TableName[Top BU 100%] = "SPLIT BU"
        )
    )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( TableName[Top BU], 1 ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[Project ID] ),
            TableName[Product Split %] = mymax
        )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

harrinho

 

Try this Column

 

Max Split BU 2 =
VAR myMax =
    CALCULATE (
        MAX ( TableName[Product Split %] ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[Project ID] ),
            TableName[Top BU 100%] = "SPLIT BU"
        )
    )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( TableName[Top BU], 1 ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[Project ID] ),
            TableName[Product Split %] = mymax
        )
    )
harrinho's avatar
harrinho
Helper III
8 years ago

thank you very much Zubair_Muhammad. It works perfect :) 

 

This is a bit too technical for me but I think I get the logic.