Measure changes when published to from Desktop to Fabric

[blaj]

I have a measure that gets thrown off misteriously when I publish from .pbix to Fabric. I checked the filter icons in both places and no additional Fabric filters are being applied. I updated Power BI. Uninstalled it, downloaded the MS Store version, created a visual with new version, saved the report in different workspace....still showing different numbers between Dekstop and Fabric. 

Please help.

Power BI Desktop

Fabric

[blaj · Accepted solution]

For some reason Power BI desktop did not take into account my incorrect filter context which was supposed to be at the Monthly level. My measure filtered at the Daily level. Desktop still displayed it at the Monthly level while Fabric did at the Daily level...

Seems like  a bug in filter context between Desktop & Fabric, unless I am missing something.

previous measure filter context:

 

var vtable =

    FILTER(

            VALUES(DATETABLE[Date]),  

            DATETABLE[Date] <= MAX(DATETABLE[Date])

        )

var result =

    SUMX(vtable,[A] - [B] - [C])

RETURN

result

    result

new measure:

    CALCULATE(

        [A] - [B] - [C],

        DATETABLE[Date] <= MAX(DATETABLE[Date])

    )

CALCULATE just works better/simpler sometimes 😊

[v-linyulu-msft]

Hi,@blaj 

We are glad that you have found a solution and are willing to share it, and accept your post for a solution, which is very helpful to our community, and community members who have the same problem as you will find a solution faster.

Thank you for your contribution to the community and wish you all the best in your work.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.