Hi All
I am stuck at a point when I created the output of WhatIF Measure it works fine here :-
| Slicer XXX = -8 | Slicer YYY = -10 | Slicer ZZZ = -11 | Slicer AAA = -65 |
| | | | |
| FY 2018 | FY 2019 | FY 2020 | Revised |
XXX | 80.00 | 85.00 | 70.00 | 62.00 |
YYY | 70.00 | 85.00 | 65.00 | 55.00 |
ZZZ | 80.00 | 85.00 | 63.00 | 52.00 |
AAA | 80.00 | 85.00 | 5.00 | (60.00) |
JFYI Measure Formula =
SUMX(Total, IF(Total[Financial Item] = "XXX" , FY 2020 + 'Slicer XXX'[Change Value]),IF(Total[Financial Item] = "YYY" , FY 2020 + 'Slicer YYY'[Change Value]) ,IF(Total[Financial Item] = "ZZZ" , FY 2020 + 'Slicer ZZZ'[Change Value]) , IF(Total[Financial Item]= "AAA" , FY 2020 + 'Slicer AAA'[Change Value]) ),FY 2020)))))
But when I try to Unpivot Table in the below manner with these Measure it does not update Slicer Value
Summarize Table =
VAR Counter = COUNTROWS(FILTERS('P&L'[Business Line]))
VAR T1 = SUMMARIZE(Total,Total[Business Line],Total[Financial Item],"Year","FY 2018", "Value", Total[Total FY 2018])
VAR T2 = SUMMARIZE(Total,Total[Business Line],Total[Financial Item],"Year","FY 2019", "Value", Total[Total FY 2019])
VAR T3 = SUMMARIZE(Total,Total[Business Line],Total[Financial Item],"Year","RFC 2020", "Value", Total[Total RFC 2020])
VAR T4 = SUMMARIZE(Total,Total[Business Line],Total[Financial Item],"Year","Revised RFC 2020", "Value",
SUMX(Total, IF(Total[Financial Item] = "XXX" , FY 2020 + 'Slicer XXX'[Change Value]),IF(Total[Financial Item] = "YYY" , FY 2020 + 'Slicer YYY'[Change Value]) ,IF(Total[Financial Item] = "ZZZ" , FY 2020 + 'Slicer ZZZ'[Change Value]) , IF(Total[Financial Item]= "AAA" , FY 2020 + 'Slicer AAA'[Change Value]) ),FY 2020))))) )
RETURN
UNION(T1,T2,T3,T4)