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
6,245 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
1 answer

How to create measure out of column

To convert the LossValue column into a ...READ MORE

answered Apr 29 in Power BI by anonymous
• 1,380 points
908 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,030 points
8,639 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
14,548 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,030 points
929 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,360 points
970 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,360 points
847 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,360 points
1,189 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
652 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
4,908 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP