File breaks after September update

[navi13]

Hello,

when I made the September update Power BI 32 bit version , the file collapsed. In August version everything is OK. The error message was I could not load database schema.

Problem was in one measure.

CMred = 
MIN (
[YTD CM_Příloha10_r2017_KU_NE45];
[YTD CM_Příloha10_r2017_KU_NE45] ^ 0,2
* (
1,05 * [YTD PP_Příloha10_r2017_KU_NE45]
* (
DIVIDE ( [YTD CM_Příloha10_r2015_KU_NE45]; [YTD PP_Příloha10_r2015_KU_NE45] )
^ 0,8
)
)
)

Now I discovered the solution – multiply by 1
CMred = 
MIN (
[YTD CM_Příloha10_r2017_KU_NE45];
[YTD CM_Příloha10_r2017_KU_NE45] ^ 0,2
* (
1,05 * [YTD PP_Příloha10_r2017_KU_NE45]
* (
DIVIDE ( [YTD CM_Příloha10_r2015_KU_NE45]; [YTD PP_Příloha10_r2015_KU_NE45] )
^ 0,8
)
)
)*1

Is it a bug?
Thanks

[v-haibl-msft]

@navi13

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 48725247
I’ll post here once I get any update about it.

Best Regards,
Herbert

[v-haibl-msft]

@navi13

I’ve got response from the Product Team.

We identified the root cause of the problem. We are making a fix for it and we also have a workaround.

Please ask the user if they have a previous release of PBI Desktop (or a x64 version). If that's the case they can open the PBIX file that show's the issue and add a calculate on top of the measure "CMred", as shown below.

CMred = CALCULATE( 
MIN (
    [YTD CM_Príloha10_r2017_KU_NE45],
    [YTD CM_Príloha10_r2017_KU_NE45] ^ 0.2
        * (
            1.05 * [YTD PP_Príloha10_r2017_KU_NE45]
                * (
                    DIVIDE ( [YTD CM_Príloha10_r2015_KU_NE45], [YTD PP_Príloha10_r2015_KU_NE45] )
                        ^ 0.8
                )
        )
))

Best Regards,
Herbert

[navi13]

Hi Herbert, I have added CALCULATE to the formula and now is pbix file OK. Do I still use CALCULATE in the next updates? Best Regards, Ivan

[v-haibl-msft]

@navi13

Before the fix is implemented, you still need to use CALCULATE. And once the fix is included in the new release, you can remove CALCULATE from the measure.

Best Regards,
Herbert