Flori_Abb's avatar
Flori_Abb
Helper I
9 years ago
Status:
Needs Info

MdxScript(Model) (108, 2) error with switch button in Power BI Service (no Problem in PBI Desktop)

Hi all   there is something weird happening in Power BI online. I upload every day a new sales report to our PBI Workspace and that has worked without problems the last 12 months! Since yesterday i...
Report Server
Flori_Abb's avatar
Flori_Abb
Helper I
9 years ago

Hi Herbert

the formula is

var_mqplanrev USD = Switch( True();
dim_measureswitch[Measure Selection] = "Month" && dim_version[Version selection] = "Plan"; Data_LBE_PLAN[MTD Plan Rev USD];
dim_measureswitch[Measure Selection] = "Quarter" && dim_version[Version selection] = "Plan"; [QTD Plan Rev USD];
dim_measureswitch[Measure Selection] = "Month" && dim_version[Version selection] = "LBE1"; Data_LBE_PLAN[MTD LBE1 Rev USD];
dim_measureswitch[Measure Selection] = "Quarter" && dim_version[Version selection] = "LBE1"; [QTD LBE1 Rev USD];
dim_measureswitch[Measure Selection] = "Month" && dim_version[Version selection] = "LBE2"; Data_LBE_PLAN[MTD LBE2 Rev USD];
dim_measureswitch[Measure Selection] = "Quarter" && dim_version[Version selection] = "LBE2"; [QTD LBE2 Rev USD];
dim_measureswitch[Measure Selection] = "Month" && dim_version[Version selection] = "LBE3"; Data_LBE_PLAN[MTD LBE3 Rev USD];
dim_measureswitch[Measure Selection] = "Quarter" && dim_version[Version selection] = "LBE3"; [QTD LBE3 Rev USD];
dim_measureswitch[Measure Selection] = "Month" && dim_version[Version selection] = "LBE4"; Data_LBE_PLAN[MTD LBE4 Rev USD];
dim_measureswitch[Measure Selection] = "Quarter" && dim_version[Version selection] = "LBE4"; [QTD LBE4 Rev USD];
blank())

 

It has worked nicely until tuesday, after that it shows this error message in PBI Service. In the desktop it still works...

Thanks a lot and KR

 

Florian

Completed Ideas