How to Convert measure to calculated column?

0 votes
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?
Jul 18 in Power BI by Phalguni
• 1,010 points
87 views

1 answer to this question.

0 votes

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.

answered Jul 18 by Avantika
• 1,500 points

Related Questions In Power BI

0 votes
0 answers

How to create measure out of column

Hi, Need help in the problem faced in ...READ MORE

Aug 14 in Power BI by anonymous
• 210 points
26 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26 in Power BI by Cherukuri
• 28,040 points
156 views
0 votes
0 answers

How to Fix error "DataFormat.Error: We couldn't convert to Number"

Hi,  I am getting below error "DataFormat.Error: We couldn't ...READ MORE

Apr 22 in Power BI by Lavdeep
• 120 points
1,505 views
0 votes
1 answer

Use Measure/ column to replace text

Hi Nithin, For example, to replace null or ...READ MORE

answered May 17 in Power BI by Cherukuri
• 28,040 points
23 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 41,660 points
43 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 41,660 points
79 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 41,660 points
58 views
+1 vote
1 answer
0 votes
1 answer

How do you add a new column with the calculated result?

Hi, You can do this with the help ...READ MORE

answered May 27 in Power BI by Avantika
• 1,500 points
25 views
0 votes
1 answer

How do I convert month format in Power BI?

Hi, This can easily be done using DAX ...READ MORE

answered Mar 26 in Power BI by Avantika
• 1,500 points
105 views