Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have two measures -
Actual Cumulative Cost = CALCULATE(SUM('K:01303 (Combined)'[Cost]),FILTER(ALL('K:01303 (Combined)'),'K:01303 (Combined)'[Month]<=MAX('K:01303 (Combined)'[Month])&&'K:01303 (Combined)'[Cost Type]="Actual Cost"))
Forecasted Cumulative Cost = CALCULATE(SUM('K:01303 (Combined)'[Cost]),FILTER(ALL('K:01303 (Combined)'),'K:01303 (Combined)'[Month]<=MAX('K:01303 (Combined)'[Month])&&'K:01303 (Combined)'[Cost Type]="Forecast"))
I have the original cost values set up where the Forecast costs show as 0 if they are posted before today's date. I've highlighted what I'd like to stay. The 2nd chart is from Excel and shows how I would like it to look. Is there a simple way to combine these while hiding the non-highlighted part?
Also, since the measures are created in DAX, any additional changes, I assume, would also have to be in DAX and not an m-formula.
Thanks,
Robyn
Solved! Go to Solution.
@Anonymous , try like
if([Forecasted Cumulative Cost])<>0,[Forecasted Cumulative Cost]+[Actual Cumulative Cost],[Actual Cumulative Cost])
@Anonymous , try like
if(not(isblank([Forecasted Cumulative Cost])),[Forecasted Cumulative Cost]+[Actual Cumulative Cost],[Actual Cumulative Cost])
@amitchandak I get an error "Model object names must be non-empty". Not sure what this means but I don't believe any of my values are blank.
@Anonymous , try like
if([Forecasted Cumulative Cost])<>0,[Forecasted Cumulative Cost]+[Actual Cumulative Cost],[Actual Cumulative Cost])
@amitchandak This works. Thank you! Now I just need to find a visual that lets me define the series by both column and line. Thank you!
Robyn
I would have thought just making a measure adding the two things together would work...
@jthomson I guess technically that would work, but wouldn't I lose the cost type/color variance if they became one value?
Robyn
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |