Graphing with What if Parameter measures

[Bokchoy]

Hi all,

I have a what-if parameter value called " target FY rev", and I created a measure that gives the daily revenue required to hit the "target FY rev". 

I'm trying to create a linear line graph that shows accumulative target revenue by date (shown below). For some reason, the measure always reverts back to the parameter value instead of the measure, giving me much higher values.

thanks in advance.

calendar predicted rev = 
##calender for rev'[index] goes from 1 to 365 
##[FY avg to hit target] is the "parameter value" / 365
var calc =  [FY avg to hit target] * SELECTEDVALUE('calender for rev'[index])

return calc

[parry2k · Accepted solution]

@Bokchoy I think this is what you need, assuming you have a calendar table with all the dates

Forecast Rev Cumulative = 
VAR __startDate = CALCULATE ( MAX ('Calendar'[Date] ), ALLSELECTED ( ) )
VAR __days = DATEDIFF ( MAX ('Calendar'[Date] ), __startDate,  DAY ) + 1
RETURN
DIVIDE ( [Parameter Value], __days )

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡