Change from measure to calculated column / percentage of sales

[nbrandborg]

Hi all,

I have following working measure in my dataset, but I need to have it as a calculated column as I need the values to be fixed when filtering.

Can anyone help me to translate the measure below?

Percentage of Sales= DIVIDE(SUM('Regional Sales'[Realised Sales]),CALCULATE(SUM('Regional Sales'[Realised Sales]),FILTER(ALLSELECTED('Regional Sales'),'Regional Sales'[Material] = MAX('Regional Sales'[Material]))))

It does follwing percentage calculation:

Best regards!

[nbrandborg]

It worked. Thank you @amitchandak !

[amitchandak · Accepted solution]

@nbrandborg , Try a new column like

Percentage of Sales= DIVIDE(('Regional Sales'[Realised Sales]),CALCULATE(SUM('Regional Sales'[Realised Sales]),FILTER(ALLSELECTED('Regional Sales'),'Regional Sales'[Material] = earlier('Regional Sales'[Material]))))