Forum Discussion

blaj's avatar
blaj
Icon for Helper I rankHelper I
2 years ago
Solved

Measure changes when published to from Desktop to Fabric

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

 

 

 

General Comment
Need Help
  • blaj's avatar
    blaj
    2 years ago

    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 😊

2 Replies

  • blaj's avatar
    blaj
    Icon for Helper I rankHelper I
    2 years ago

    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 😊
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.