Forum Discussion
Solved
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.
Hi Ninna
You can activate and rename the total column then place the following measure in the matrix instead of the original measureResultMeasure = 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 )
2 Replies
- tamerj1
Community Champion
Hi Ninna
You can activate and rename the total column then place the following measure in the matrix instead of the original measureResultMeasure = 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 )Great, that is it. Thanks 🙂
