Forum Discussion
Solved
create a calculated column while ignoring row context
I am tyring to calculate montly percentages from a ledger using a date table. My data looks something like this So Jan's % = 100, Feb % = 100, Mar % = 100 I can't get it to work in DA...
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
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