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, 2019 in Power BI by Phalguni
• 1,020 points
4,769 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, 2019 by Avantika
• 1,520 points

Related Questions In Power BI

+2 votes
0 answers

How to create measure out of column

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

Aug 14, 2019 in Power BI by anonymous
• 230 points
315 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, 2019 in Power BI by Cherukuri
• 33,010 points
6,247 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, 2019 in Power BI by Lavdeep
• 120 points
12,547 views
0 votes
1 answer

Use Measure/ column to replace text

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

answered May 17, 2019 in Power BI by Cherukuri
• 33,010 points
346 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
• 52,350 points
356 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
• 52,350 points
313 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
• 52,350 points
525 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, 2019 in Power BI by Avantika
• 1,520 points
228 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 27, 2019 in Power BI by Avantika
• 1,520 points
3,842 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP