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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
blaj
Helper I
Helper I

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
Helper I
Helper I

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
Helper I
Helper I

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors