Combine two measures into a new measure

[Chanise89]

My apologies if this question seems redundant. But I cant find a solution to my issue. 

I have two measures:

Forecast Scenario and Forecast HC (QYear) 

I need to create two separate meausures from these two columns:

Forecast HC - Prior 

Forecast HC - Current 

I know that I can just use the scenario column as a filter but I need to create the measures as they want to see Prior vs Current on a line graph.

Please help

[Ashish_Mathur · Accepted solution]

Hi,

This pattern should work

Forecast HC - Prior = calculate(sum(Data[Amount]),Data[]="Prior")

Forecast HC - Current = calculate(sum(Data[Amount]),Data[]="Current")

Hope this helps.

[Chanise89]

This worked perfectly! Thank you 🙂 

[Ashish_Mathur]

You are welcome.

[v-cgao-msft]

Hi @Chanise89 ,

//I have two measures: Forecast Scenario and Forecast HC (QYear) 

It seems that [Forecast Scenario] should be a field in the table, otherwise the table visual should have only one row.

Fields/calculated columns can be placed in Legend buckets. Try creating a line chart with the field you need (e.g. month) on the x-axis, the measure [Forecast HC (QYear)] on the y-axis , and 'TableName'[Forecast Scenario] in the Legend, and two lines should appear.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Chanise89]

These two columns are in the same table. I'm just trying to combine these two measure into one. 

I tried concatenate but it doesnt work

[Alex_Sawdo]

It depends on how your model/table structure is in this case. Can you share some more details about your data model?