Forum Discussion
create a calculated column while ignoring row context
Hi adgarza,
You can create a measure below:
Measure = CALCULATE(SUM('fact'[Amount]),FILTER(ALL('date'),'date'[Year]=MAX('date'[Year])))
Best Regards,
Qiuyun Yu
I believe the first step is to create a measure that is a sum by month. This can be checked by adding into the visual.
MonthSum =
CALCULATE (
SUM ( 'Table'[Amount] ),
ALLEXCEPT ( 'Table', 'Table'[Month] )
)
If i put it in a table i want it to look like this.
Year is from a date table, buying channel and amount are from a fact table, and total is the new measure. Notice it stays the same for each year.
Year Buying Channel Amount Total 2000 PO 1 6 2000 NONPO 2 6 2001 PCARD 3 6 2001 PO 4 15 2001 NONPO 5 15 2001 PCARD 6 15 2002 PO 1 6 2002 NONPO 2 6 2002 PCARD 3 6
Hi adgarza,
You can create a measure below:
Measure = CALCULATE(SUM('fact'[Amount]),FILTER(ALL('date'),'date'[Year]=MAX('date'[Year])))
Best Regards,
Qiuyun Yu