GROUP BY Measure in Power BI

[anandraman]

Hi I have a  3 Tables BU , BG and Fact

 

 

I want a measure to calculate the SUM always at BU level. Whatever column is select in the report  along with BU this column should always give me SUM(SALES) at BU level and repeat it for all the different value of other columns in the report.

This is what i am expecting:

Any suggestions?

[v-chuncz-msft · Accepted solution]

@anandraman,

You may refer to the following measure.

Measure =
CALCULATE ( SUM ( 'Fact'[Sales] ), ALLEXCEPT ( 'Fact', 'Fact'[BU ID] ) )