I have 7 calculated columns and need to compare the counts for various years.
I am trying to get the chage value as column but unable to get it .
If I create the Change measure as Column it throws error for SAMEPERIODLASTYEAR which i have used.
Hi @srisandanavelli ,
Did these FY field measure or column? If column, you can add a measure with if condition to check current row contents to switch measure result of current formula.
Measure = IF ( ISFILTERED ( Table[FY] ), CALCULATE ( SUM ( Table[Value] ), ALLSELECTED ( table ), VALUES ( Table[Cateogry] ) ), IF ( [No of key Risks] - [Next\Pevious year] > 0, "Low", "Up" ) )
If they are measures, you can direct add three measures to value field and remove column fields.