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.
... View more