Forum Discussion
Anonymous
4 years agoNot applicable
How to get difference between two columns in Matrix based on slicer selection of Year in Power Bi
- 4 years ago
Hi Anonymous
Here you go https://www.dropbox.com/t/sMyzwonHckNHvdKX
Original Measure code remains the sameMeasure = COUNTROWS ( DISTINCT ('Table'[Value] ) )New Measure code is
Measure1 = VAR MaxYear = MAX ( 'Table'[Year] ) VAR MinYear = MIN ( 'Table'[Year] ) VAR MaxYearValue = CALCULATE ( [Measure], 'Table'[Year] = MaxYear ) VAR MinYearValue = CALCULATE ( [Measure], 'Table'[Year] = MinYear ) VAR Difference = MaxYearValue - MinYearValue VAR Result = SWITCH ( TRUE, NOT HASONEVALUE ( 'Table'[Year] ), Difference, COUNTROWS ( ALLSELECTED ('Table'[Year] ) ) = 1, BLANK(), [Measure] ) RETURN Result
tamerj1
Community Champion
4 years agoHi Anonymous
Here you go https://www.dropbox.com/t/sMyzwonHckNHvdKX
Original Measure code remains the same
Measure = COUNTROWS ( DISTINCT ('Table'[Value] ) )New Measure code is
Measure1 =
VAR MaxYear = MAX ( 'Table'[Year] )
VAR MinYear = MIN ( 'Table'[Year] )
VAR MaxYearValue =
CALCULATE (
[Measure],
'Table'[Year] = MaxYear
)
VAR MinYearValue =
CALCULATE (
[Measure],
'Table'[Year] = MinYear
)
VAR Difference = MaxYearValue - MinYearValue
VAR Result =
SWITCH (
TRUE,
NOT HASONEVALUE ( 'Table'[Year] ), Difference,
COUNTROWS ( ALLSELECTED ('Table'[Year] ) ) = 1, BLANK(),
[Measure]
)
RETURN
Result
Anonymous
4 years agoNot applicable
Thank You So Much Tamerj1 .
You deserve to be a super user .
Kudos ! Kudos !