Forum Discussion

ES_TH's avatar
ES_TH
Frequent Visitor
2 years ago
Solved

PowerBi Matrix Table - Compare 2 different variables of same object

Hi,   I am using PowerBi and am trying to solve a problem of comparing the outcomes of 2 columns that are showing the same object but with 2 possible outcomes. Basically it's almost a what if sce...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ES_TH 

     

    For your question, here is the method I provided:

     

    First, go to the power query and Unpivot Columns for Apples and Apples-1.

     

     

     

    Create a measure.

     

    Measure = 
    CALCULATE(
        COUNT('Table'[Attribute]), 
        FILTER(
            'Table', 
            'Table'[Attribute] = MAX('Table'[Attribute]) 
            && 
            'Table'[Value] = MAX('Table'[Value])
        )
    )

     

    Here is the result.

     

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ES_TH 

 

For your question, here is the method I provided:

 

First, go to the power query and Unpivot Columns for Apples and Apples-1.

 

 

 

Create a measure.

 

Measure = 
    CALCULATE(
        COUNT('Table'[Attribute]), 
        FILTER(
            'Table', 
            'Table'[Attribute] = MAX('Table'[Attribute]) 
            && 
            'Table'[Value] = MAX('Table'[Value])
        )
    )

 

Here is the result.

 

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

ES_TH's avatar
ES_TH
Frequent Visitor
2 years ago

Hi,

 

This is an excellent solution.  Thank you.  As I am new to this I just wanted to understand some the logic in this.  I get the pivoting which is fine but it is the measure that doesn't qute make sense to me and also I am having problems calculating percenatge change as I thought you could use the  "New Calculation" on visula but it doesn't seem to recognise the columns.  So getting to the point and being more explicit see the logic I was trying to ascertain from visuals:

 

 

1. What is the point of the measure if I get the same output from just using the attributes in the values and doing a count

 

2.  What is the Filter with max for attribute and value adding.

 

3. How do I get to do calculations on these columns?  I thought the "new calculation" on visual would of helped but it doesn't seem to recognise the measure column so I can tell it to calculate percentage change for Apples and Apples-1 (I'm sure it is really simple and my syntax understanding is just missing as newbie to all of this!!!).  Should I or do I even need to do it on the visual?  How would I write a measure to show me this (research says that you can't format visual calculations!).

 

Sorry lots of questions but hope that makes sense.  Will upload PBI file if i can figure out how!  😁