Forum Discussion

heiavieh's avatar
heiavieh
Frequent Visitor
2 years ago
Solved

Measure - Column reference for CALCULATE(SUM(), FILTER() based on values?

I'm sure there's a post familiar to this somewhere on the forum, but I could not find it.   I have a table that records accumulated metrics for business units. Here is an example, I'm using Excel j...
Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

    You can try using ALLEXCEPT in your measure. Microsoft Learn - ALLEXCEPT 

    BU Actual Total = 
CALCULATE(
    SUM('Table'[Actual]),
    ALLEXCEPT('Table', 'Table'[Business Unit])
)

     

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
2 years ago

You can try using ALLEXCEPT in your measure. Microsoft Learn - ALLEXCEPT 

BU Actual Total = 
CALCULATE(
    SUM('Table'[Actual]),
    ALLEXCEPT('Table', 'Table'[Business Unit])
)