Creating Cumulative What If Line

[JiaJie]

Hi,

I am currently trying to create a cumulative what if line which can be adjusted by the user on a slicer when a what if parameter is created. I have created a what if line but is currently horizontal despite creating a new rolling total meausure.

Does anyone knows how to create cumulative what if parameter line? 

An example of what I am looking for to create:

Currently:

[Anonymous · Accepted solution]

Hi  @JiaJie ,

Here are the steps you can follow：

1. In Power query, Add Column – Index Column – From 1.

2. In Modeling – New parameter.

Minimum = 5

Maximum = 45

Increment = 5

3. Create calculated column.

Index = RANKX('Parameter','Parameter'[Parameter],,ASC)

4. Create the relationship between the two tables with [Index]

5. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@JiaJie , a measure like

Countx(filter(allselected(Table), Table[shift_info] <=max(Table[shift_info] ) ),Table[shift_info] ) *5

or

Countx(filter(allselected(Table), Table[shift_info] <=max(Table[shift_info] ) ),Table[shift_info] ) * [what if measure]

[JiaJie]

Hi  @amitchandak,

I have tried using your CountX method however it is counting the number of shift info multiplying the what if.

However I am looking to just create a Y=MX line M is the what if number. I have tried to create a distinct table of shift info and rank it follow by muktiplying the what if. But it is still giving me a flat line.