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.
Hello
Not even sure its possible but can anyone help me do a measure that can be used in a Line Graph that shows Month at the bottom and Totals on the side.
I want the monthly total for overtime.
I think the problem is I have page filters so it keeps changing it.
I tried something like -
Month by Month = CALCULATE(SUM('DB Overtime Master'[Total],FILTER('Month','Month'[Month])))
Thanks
Ross
Solved! Go to Solution.
Do you mean like this?
Your measure is the Value and your month is the Axis.
Alter your measure to this:
CALCULATE(SUM('DB Overtime Master'[Total],ALL('Month'[Month]))
Do you mean like this?
Your measure is the Value and your month is the Axis.
Alter your measure to this:
CALCULATE(SUM('DB Overtime Master'[Total],ALL('Month'[Month]))
Thank you. Sometimes its quite frustrasting as it can be a , or ( in the wrong place and throws whole thing out.
I'm not clear what do you want to achieve
do you mean YTD calculation? can you share sample data?
Hello,
Something like this.
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 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |