Getting comparison in Column

[Anonymous]

Hi All,

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.

Meausres:

FY-FY Change = IF([No of key Risks]-[Next\Pevious year]>0 ,"Low", "Up")

Where No of key risks is a measure.
Next\Pevious year= No of key risks for pervious or next year.

Need the above highlighted row as column value for each row.

Please suggest and feel free to reach out for any information.

[v-shex-msft]

Hi @Anonymous ,

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.

Regards,

Xiaoxin Sheng