Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PK_PBIBoss
Frequent Visitor

What IF Parameters not working when unpivoting the Measure to Rows

Hi All

 

I am stuck at a point when I created the output of WhatIF Measure it works fine here :- 

 Slicer XXX = -8Slicer YYY = -10Slicer ZZZ = -11Slicer AAA = -65
     
 FY 2018 FY 2019FY 2020Revised
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)
1 ACCEPTED SOLUTION
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.