How to Convert measure to calculated column

Question

Hi,

I am trying to create a scenario analysis page in Power BI. My data consist of projects and their forecast which are spent each financial year. These projects are ranked based on their importance and for their cumulative spend of the projects by rank can not exceed a cut-off dollar value.

I can select the financial years applicable for analysis and also the cut-off amount using slicers

I have created a measure that correctly calculates the cumulative spend.

However to visualize the data, I need to turn the ‘is cutoff’ measure into a calculated column so that it can be used in a slicer or filter.

How do I do this?

Answer 1

Hi,

I have created a new measure using the 'is cutoff' measure. 

**bleep** Sum = IF(HASONEVALUE(project[Prj Code]),
CALCULATE(
	 SUM(spend[Amount]), FILTER(
		ALLSELECTED(project),
		project[Rank] <= MAX(project[Rank]))
)
)

is cutoff = IF([**bleep** Sum] >[Selected cutoff], 1, 0)

Above cutoff = IF([is cutoff] = 0, SUM(spend[Amount]), BLANK())

Below cutoff = IF([is cutoff] = 1, SUM(spend[Amount]), BLANK())

 Put both measures onto the same bar chart, to have a dynamically changing chart based on my two slicers.