Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 DAX. I've tried
% total = DIVIDE( SUM(Append1[Amount]), CALCULATE( SUM(Append1[Amount]), ALL(Append1[Buying Channel]) ) )
I'm trying to get DAX to ignore the Buying channel context and just use the date context.
Any ideas? Is it messing up because of the date table?
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |