Forum Discussion

gonnelli's avatar
gonnelli
Frequent Visitor
7 years ago
Solved

Difference between 2 rows using first row fixed

Hello!   I need to calculate the difference between two rows in a matrix table in Power BI, but I need to keep the first row as reference, like this:   EDIT: The first row (Model "A") can be chan...
General Comment
Need Help
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi gonnelli,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.


    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi gonnelli,

 

Two ways you can choose.

 

1. To create a calculated column.

 

diffc = Table1[price]-CALCULATE(SUM(Table1[price]),FILTER(ALL(Table1),Table1[model]="A"))

2. To create a measure.

 

diffm = MAX(Table1[price])-CALCULATE(SUM(Table1[price]),FILTER(ALL(Table1),Table1[model]="A"))

For more details, please check the pbix as attached.

 

Regards,

Frank