Hello, I am experiencing very weird issue while analyzing the data from SSAS Tabular Model Cube chained (or linked if you prefer) measures. Please allow me to use an example: I do have a table with project budgets and columns Client Budget and Investment Budget. In this table in the cube I created three measures: MeasureA := SUM([Client Budget]) MeasureB := SUM([Investment Budget]) MeasureC := MeasureA + MeasureB My table with budgets has a reference to project dimension so I can slice this data by for example project name. In PowerBI desktop I have created a table with following columns: Project name|MeasureA|MeasureB|MeasureC and I am experiencing following issue - whenever I refresh the data with Refresh button (data in DB and cube is not changing, just refreshing the report view) results of MeasureC are different instead of being a sum of Measures A and B all the time. Weirdly every time I hit refresh MeasureC is either - 0 - equal MeasureA - equal MeasureB - correct and equal a sum When I connect to the cube through power pivot or directly from SSMS browser the values are always correct which is leading me to believe that formulas are correct and something is off with the PowerBI desktop.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Scheduled Refresh for Fabric Mirroring
Current Challenge: Fabric Mirroring runs continuously, leading to unnecessary data replication and higher Snowflake costs. There is no built-in option to schedule mirroring based on specific times o...ram_eternal18936 minutes agoRegular VisitorNeeds Votes468Views3likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen1 hour agoAdvocate INew256Views42likes1CommentWhy are Calculation Groups so hard to modify?
Is there a way to make it easier to modify the DAX in a calculation group? I'm not sure if it's just me that finds this so annoying, but perhaps it's because I just started using calculation groups. ...AaronReasoner2 hours agoNew MemberNew2Views0likes0CommentsFeature Request: Add a Warning Prompt Before Deleting Tables That Contain Measures
Problem Statement: In Power BI, measures are linked to specific tables. When a developer deletes a table from the model view or report view, Power BI automatically deletes all measures assigned to ...Murtaza_Ghafoor5 hours agoSuper UserNew15Views2likes0CommentsCustom visuals: allow same-tab navigation & reduce confirm-navigation friction for trusted links
Description: Custom visuals (e.g. Deneb) that trigger navigation via href currently have two limitations that create friction for legitimate, author-controlled use cases: Links always open in a ne...AlexSenEON7 hours agoNew MemberNew9Views0likes0Comments