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
Add a Close or “Return to previous page” button to Semantic Model Security and Settings pages
When updating RLS group assignments through Semantic model > Security, there is no consistent in-product Close or Done button that returns the user to the previous workspace view. The browser Back b...Kalaiselvan26 minutes agoFrequent VisitorNew2Views0likes0CommentsRetain Comments and Formatting in Power Query within Dataflow
I imagine this is part of the pipeline for development of Dataflows by the time it comes out of Preview. Currently all comments and formatting that is written into the Power Query of a Dataflow is st...tmckenzie31 hour agoNew MemberUnder Review316Views22likes4CommentsEnable field parameters for live connection
One of the limitations of the use of Power BI field parameters is that they can't be used in a live connection model. I request this feature to be enabled since field parameters are hyper useful fo...MSteidl2 hours agoNew MemberNeed Clarification2.9KViews54likes12CommentsEnable SharePoint File Support in Fabric Copy Jobs
Idea description Microsoft Fabric Copy Jobs currently do not support reading from or writing files directly to SharePoint sites. This limitation makes it difficult to implement straightforward and r...arno_cd924 hours agoNew MemberNew2Views0likes0CommentsAdd a "Collapse All Code Cells" option in Fabric Notebooks
Title: Add a "Collapse All Code Cells" option in Fabric Notebooks Fabric Notebooks currently allow users to collapse code cells individually. However, in large notebooks, manually collapsing each ce...arno_cd924 hours agoNew MemberNew4Views0likes0Comments