Integrations with Files and Services

Highlighted
Frequent Visitor
Posts: 8
Registered: ‎03-01-2017

Help with new Measure

[ Edited ]

Hello there,

I'm kind of new in Power BI, and I was wondering if is it possible to create a new measure using two variables of two different query's. I took the EdX course, but I don't remember to have an exercise like this.

For sure, if this is possible I will appreciate the advice of how to do it. Step by step likely. Hope someone sees my question and answer it.

The function that I need to do is a difference. Variable A, subtract Variable B (A-B).

Best regards.

Accepted Solutions
Established Member
Posts: 153
Registered: ‎08-24-2015

Re: Help with new Measure

Hi Josepatwentysix

I'm not sure if I fully understood your question, but I'll try to answer the question.

You have to create 3 measures in PBI Desktop.

1. Measure:

FirstMeasure = sum(Tabelle1[A])

2. Measure:

SecondMeasure = sum(Tabelle1[B])

Difference Measure:

Difference = [FirstMeasure] - [SecondMeasure]

Greetings

Hp Pfister

Measure A: calculate something

Measure B: calculate something

Measure Difference: = A - B

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com

All Replies
Established Member
Posts: 153
Registered: ‎08-24-2015

Re: Help with new Measure

Hi Josepatwentysix

I'm not sure if I fully understood your question, but I'll try to answer the question.

You have to create 3 measures in PBI Desktop.

1. Measure:

FirstMeasure = sum(Tabelle1[A])

2. Measure:

SecondMeasure = sum(Tabelle1[B])

Difference Measure:

Difference = [FirstMeasure] - [SecondMeasure]

Greetings

Hp Pfister

Measure A: calculate something

Measure B: calculate something

Measure Difference: = A - B

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com
Frequent Visitor
Posts: 8
Registered: ‎03-01-2017

Re: Help with new Measure

[ Edited ]

Of course, that's what I've learned already when both varibles correspond to the same Query. I was talking more like when one variable is from one Query or folder, and the other variable is from a different Query or folder.
But if you wanted to say Tabelle1 and Tabelle 2, I guess you right, I'm gonna try with your explanation and promote you to solution.