Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
If I don't use the "Date hieachy" in the X axis but just the date, it does work but that is not what I want to do.
Thank you
Solved! Go to Solution.
I just realize that when using Quick measures you can select the hierarchi level for which you want the running total to work, if you just add them all (select one on the user interface then add the rest on the formula bar), the graph should work.
CALCULATE(
SUM(BaselineTrackingVariableBase[Adj]),
FILTER(
CALCULATETABLE(
SUMMARIZE(
' BaselineTrackingVariableBase',
' BaselineTrackingVariableBase' [Action Date].[MonthNo],
' BaselineTrackingVariableBase' [Action Date].[Year],
' BaselineTrackingVariableBase' [Action Date].[Quarter],
' BaselineTrackingVariableBase' [Action Date].[Month]
),
ALLSELECTED(' BaselineTrackingVariableBase')
),
ISONORAFTER(
' BaselineTrackingVariableBase' [Action Date].[MonthNo], MAX(' BaselineTrackingVariableBase' [Action Date].[MonthNo]),DESC,
' BaselineTrackingVariableBase' [Action Date].[Year], MAX(' BaselineTrackingVariableBase' [Action Date].[Year]),DESC,
' BaselineTrackingVariableBase' [Action Date].[Quarter], MAX(' BaselineTrackingVariableBase' [Action Date].[Quarter]),DESC,
' BaselineTrackingVariableBase' [Action Date].[Month], MAX(' BaselineTrackingVariableBase' [Action Date].[Month]),DESC
) && BaselineTrackingVariableBase[Type] = "Baseline"
)
)
I just realize that when using Quick measures you can select the hierarchi level for which you want the running total to work, if you just add them all (select one on the user interface then add the rest on the formula bar), the graph should work.
CALCULATE(
SUM(BaselineTrackingVariableBase[Adj]),
FILTER(
CALCULATETABLE(
SUMMARIZE(
' BaselineTrackingVariableBase',
' BaselineTrackingVariableBase' [Action Date].[MonthNo],
' BaselineTrackingVariableBase' [Action Date].[Year],
' BaselineTrackingVariableBase' [Action Date].[Quarter],
' BaselineTrackingVariableBase' [Action Date].[Month]
),
ALLSELECTED(' BaselineTrackingVariableBase')
),
ISONORAFTER(
' BaselineTrackingVariableBase' [Action Date].[MonthNo], MAX(' BaselineTrackingVariableBase' [Action Date].[MonthNo]),DESC,
' BaselineTrackingVariableBase' [Action Date].[Year], MAX(' BaselineTrackingVariableBase' [Action Date].[Year]),DESC,
' BaselineTrackingVariableBase' [Action Date].[Quarter], MAX(' BaselineTrackingVariableBase' [Action Date].[Quarter]),DESC,
' BaselineTrackingVariableBase' [Action Date].[Month], MAX(' BaselineTrackingVariableBase' [Action Date].[Month]),DESC
) && BaselineTrackingVariableBase[Type] = "Baseline"
)
)
hi @bklyn3
in cases like this, i would
1) create needed month, quarter columns in the Date Table.
2) write different measures for running total over different levels. e.g. if running over quarter, we put quarter inside MAX.
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
19 | |
14 |