Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Getting comparison in Column

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 Co...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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