Forum Discussion

Josepatwentysix's avatar
Josepatwentysix
Frequent Visitor
9 years ago
Solved

Help with new Measure

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 h...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

 

 

 

 

Josepatwentysix's avatar
Josepatwentysix
Frequent Visitor
9 years ago

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.