Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |