Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Sum_Scenario_Year =
//example of recalled measures
//ACT CY = CALCULATE(SUM('CAPEX FOR ENG'[SCENARIO_VALUE]),'CAPEX FOR ENG'[SCENARIO] = "ACT" , DATESYTD(TIME[Date]))
// ACT - 1 = CALCULATE(SUM('CAPEX FOR ENG'[SCENARIO_VALUE]),'CAPEX FOR ENG'[SCENARIO] = "ACT" , DATEADD(DATESYTD(TIME[Date]), -1, YEAR))
// PCL CY = CALCULATE(SUM('CAPEX FOR ENG'[SCENARIO_VALUE]),'CAPEX FOR ENG'[SCENARIO] = "PCL" , DATESYTD(TIME[Date]))
VAR Scenario_value =SWITCH(SELECTEDVALUE('MAIN BASELINE'[MAIN BASELINE]),
"ACT CY" , [ACT CY],
"ACT -1", [ACT -1],
"PCL CY" , [PCL CY],
)
RETURN
Scenario_value
//if (hasonevalue('MAIN BASELINE'[MAIN BASELINE]),Scenario_value , [ACT CY]+[ACT -1]+[ACT -2]+[ACT -3]+[FCT CY]+[BDG CY]+[PCL CY]+[EST CY]+[CMT CY]+[FTR + 1]+[FTR + 2]+[FTR + 3]+[FTR + 4]+[FTR + 5])
Solved! Go to Solution.
Hi @Anonymous
please try
Sum_Scenario_Year =
SUMX (
VALUES ( 'MAIN BASELINE'[MAIN BASELINE] ),
SWITCH (
'MAIN BASELINE'[MAIN BASELINE],
"ACT CY", [ACT CY],
"ACT -1", [ACT -1],
"PCL CY", [PCL CY]
)
)
Hi @Anonymous
please try
Sum_Scenario_Year =
SUMX (
VALUES ( 'MAIN BASELINE'[MAIN BASELINE] ),
SWITCH (
'MAIN BASELINE'[MAIN BASELINE],
"ACT CY", [ACT CY],
"ACT -1", [ACT -1],
"PCL CY", [PCL CY]
)
)
HI @amitchandak ,
I tried as you indicated but I still don't see the total when I have two scenarios 😞
FEST
@Anonymous , Change return like
Sumx( values('MAIN BASELINE'[MAIN BASELINE]), Scenario_value)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |