Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

ALLEXCEPT with filter

Hi everyone,   I am calculating [Cost Total] that takes all values in [Cost in 000]. Below formula works but I want to also include [Organization] = "IND" and "COO"   Cost Total = CALCULATE(SUM('...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous,

    You can try to use the following measure formula if it suitable for your requirement:

    Cost Total =
CALCULATE (
    SUM ( 'Details Actuals+FC (Selection)'[Cost in 000] ),
    FILTER (
        ALLSELECTED ( 'Details Actuals+FC (Selection)' ),
        'Details Actuals+FC (Selection)'[Organization] IN { "IND", "COO" }
    ),
    VALUES ( 'Details Actuals+FC (Selection)'[Project Name] ),
    VALUES ( 'Details Actuals+FC (Selection)'[Year] ),
    VALUES ( 'Details Actuals+FC (Selection)'[Element Category] )
)

    Regards,

    Xiaoxin sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous,

You can try to use the following measure formula if it suitable for your requirement:

Cost Total =
CALCULATE (
    SUM ( 'Details Actuals+FC (Selection)'[Cost in 000] ),
    FILTER (
        ALLSELECTED ( 'Details Actuals+FC (Selection)' ),
        'Details Actuals+FC (Selection)'[Organization] IN { "IND", "COO" }
    ),
    VALUES ( 'Details Actuals+FC (Selection)'[Project Name] ),
    VALUES ( 'Details Actuals+FC (Selection)'[Year] ),
    VALUES ( 'Details Actuals+FC (Selection)'[Element Category] )
)

Regards,

Xiaoxin sheng