Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
blaj
New Member

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

blaj_1-1719260350646.png

 

Fabric

blaj_2-1719260426062.png

 

 

 

1 ACCEPTED SOLUTION
blaj
New Member

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 😊

View solution in original post

2 REPLIES 2
blaj
New Member

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 😊

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.