Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ninna
Frequent Visitor

Calculating difference between columns in matrix view based on filter

Hi,

 

let's say I have matrix table visual with months in rows and countries in columns, and in filter I choose which countries I want to compare.

I need to get column (red in picture) that will calculate % difference between selected countries and that depends on what country I choose in filter. 

 

Ninna_1-1677058566576.png

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Ninna 
You can activate and rename the total column then place the following measure in the matrix instead of the original measure

ResultMeasure =
VAR NormalValue = [OriginalMeasure]
VAR SelectedCountries =
    ALLSELECTED ( 'Table'[Country] )
VAR Country1 =
    MAXX ( SelectedCountries, 'Table'[Country] )
VAR Country2 =
    MINX ( SelectedCountries, 'Table'[Country] )
VAR Country1Value =
    CALCULATE ( [OriginalMeasure], 'Table'[Country] = Country1 )
VAR Country2Value =
    CALCULATE ( [OriginalMeasure], 'Table'[Country] = Country2 )
VAR Difference = Country2Value - Country1Value
RETURN
    IF ( HASONEVALUE ( 'Table'[Country] ), NormalValue, Difference )

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Ninna 
You can activate and rename the total column then place the following measure in the matrix instead of the original measure

ResultMeasure =
VAR NormalValue = [OriginalMeasure]
VAR SelectedCountries =
    ALLSELECTED ( 'Table'[Country] )
VAR Country1 =
    MAXX ( SelectedCountries, 'Table'[Country] )
VAR Country2 =
    MINX ( SelectedCountries, 'Table'[Country] )
VAR Country1Value =
    CALCULATE ( [OriginalMeasure], 'Table'[Country] = Country1 )
VAR Country2Value =
    CALCULATE ( [OriginalMeasure], 'Table'[Country] = Country2 )
VAR Difference = Country2Value - Country1Value
RETURN
    IF ( HASONEVALUE ( 'Table'[Country] ), NormalValue, Difference )
Ninna
Frequent Visitor

Great, that is it. Thanks 🙂

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.