Percentage Difference

[SHILL]

I have the example graph below and I need to get a percentage that shows the difference against our start of year plan. For example, the start of the year plan we forecast a total of 30 sales, the Q1 plan forecasted a total of 37, which is 185% against the start of year plan. Then Q2 we forecast which is 300% against the start of year plan. Is there a measure I can use to get this

Plan Forcasted		Month	Totals
Start of year		JAN	5
Start of year		FEB	10
Start of year		MARCH	5
Q1		JAN	7
Q1		FEB	10
Q1		MARCH	20
Q2		JAN	10
Q2		FEB	20
Q2		MARCH	30

[Irwan · Accepted solution]

hello @SHILL 

please check if this accomodate your need.

Create a measure wiht following DAX:

Calculate =

var _Status = SELECTEDVALUE('Table'[Plan Forcasted])

var _StartofYear = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Start of year")

Var _Q1 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q1")

var _Q2 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q2")

Return

IF(

    _Status="Start of year",

    "",

IF(

    _Status="Q1",

    DIVIDE(_Q1,_StartofYear),

IF(

    _Status="Q2",

    DIVIDE(_Q2,_StartofYear)

)))

Hope this will help you.

Thank you.