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
Allow selecting specific Fabric items to pull when using Update from Git
I’d like to suggest adding selective item deployment to Microsoft Fabric’s Update from Git experience. Today, when a Fabric workspace is connected to Git, Update from Git is primarily focused on syn...dprenc_elixirr2 hours agoAdvocate INew4Views0likes0CommentsDependency-aware Update from Git operations
I’d like to suggest improving Update from Git in Microsoft Fabric so that it becomes more dependency-aware during deployments. Git deployment can become fragile when multiple Fabric items depend on ...dprenc_elixirr2 hours agoAdvocate INew2Views0likes0CommentsAPI for Get Refresh Schedule of Dataflows
Currently, there is no way to get the actual refresh schedules of dataflows through the API. It is very important to see the coordination of dataflow and dataset refresh schedules. This seems like a...Andrew_Foulk23 hours agoNew MemberNew590Views28likes5CommentsExport Report Access Matrix for Workspace Admins
Title Allow Workspace Admins to Export Report Access and Permissions Without Tenant Admin Rights Product Microsoft Fabric / Power BI Service Business Need As a Workspace Administrator, I need a ...DonLloydLopez4 hours agoNew MemberNew5Views0likes0Comments