Forum Discussion
Adding measure while using SSAS tabular datasource corrupt the whole report
HI Dars,
I might be misunderstanding but I think the problem is because you are using a SSAS Tabular datamodel, not a local PBI datamodel. Thus you need to add the measures to the remote SSAS data model. Same for SSAS MD I would have thought?
If you have chosen the SSAS Tabular data connection my understanding is that the data is coming direct from SSAS, not being stored in the local PBIX, so not able to add measures or calculated columns in the local data model.
Anybody else agree / disagree?
Rob
Hello Rob,
I understand but I would not allow to add local measure if the source doesn't permit it. Whenever a user have a specific need for a report, I don't want to add tons of measures covering all theses particular needs in the cube for a single report. We already have a lot of measures and I like having the flexibility defining ad-hoc measures in the PBI model.
The funny thing is that when add a local measure and it works, so the mechanic is there. But everything gets messed up whenever a slicer selection is changed.