topic Where does DAX expression reside in pbix ? in DAX Commands and Tips

Where does DAX expression reside in pbix ?

Anonymous — Fri, 18 Dec 2020 09:52:10 GMT

Hi Everyone,

We are planning to publish a report from PBI but we want to publish Model and Report seperately so that the model can be used for other reports. So if create a measure in report using DAX expresssion does it reside only in report or model ?

Also is there a case where it could reside either of those places ?

Regards,

Mohan

Re: Where does DAX expression reside in pbix ?

amitchandak — Fri, 18 Dec 2020 10:27:25 GMT

Anonymous , if you, consider the model as something that is the output of power query then it(Dax formula, column/measure) resides at the report level.

Re: Where does DAX expression reside in pbix ?

daxer-almighty — Sun, 20 Dec 2020 11:56:40 GMT

How hard would it be to check which version in right? These days, when you can have composite models with different data sources, measures can reside in either of these places, but I'd say they'll never reside in both at the same time.

Re: Where does DAX expression reside in pbix ?

AntrikshSharma — Mon, 21 Dec 2020 18:14:07 GMT

Anonymous If you create a model measure such as Total Sales, it will reside in the model and will be included in all of the reports, and if you create a report measure which consumes Total Sales, then that measure will be local to a report and won't be accessible in other reports.