- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Help with new Measure

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-01-2017 08:59 PM - edited 03-01-2017 09:02 PM

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.

Solved! Go to Solution.

Accepted Solutions

## Re: Help with new Measure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-02-2017 12:50 AM

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

All Replies

## Re: Help with new Measure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-02-2017 12:50 AM

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

## Re: Help with new Measure

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-02-2017 11:32 AM - edited 03-02-2017 11:53 AM

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.