Forum Discussion
anandraman
Helper I
Helper IGROUP BY Measure in Power BI
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?
You may refer to the following measure.
Measure = CALCULATE ( SUM ( 'Fact'[Sales] ), ALLEXCEPT ( 'Fact', 'Fact'[BU ID] ) )
1 Reply
v-chuncz-msftCommunity Support
You may refer to the following measure.
Measure = CALCULATE ( SUM ( 'Fact'[Sales] ), ALLEXCEPT ( 'Fact', 'Fact'[BU ID] ) )