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])
)

     

fahadqadir3's avatar
fahadqadir3
Icon for Solution Supplier rankSolution Supplier
2 years ago

heiavieh Please review the attached screenshot, and use the following measure to sum based on Business Unit.

Measure Fixed = CALCULATE(
    SUM('Table'[value]),
    ALLEXCEPT('Table','Table'[BU])
    )

Regards,

Fahad Qadir

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!