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 B...
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 😊
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.