Forum Discussion
Adding a Dax measure to a report based on a shared data set.
I tried to re-pro the issue from my end.
Added New Qucik Measure in the above report.
Tried to connect to the above on with Power BI Dataset and created a new measure, please check with the "salary" measure column.
I am using August-2019 Power BI Desktop.
May i know the desktop version you are currently using.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?
venal Thank you for taking the time to look at this, much appreciated.
Having seen your examples I have tried again and have made some progress but havent really solved the problem.
I'm using October 2019 version of BI desktop.
It seems I can add a measure so long as it doesnt reference the dataset. For example based on your screen shots if I added a measure such as:
Bonus = 'EMP'[Sal]
it doesnt work - the measure creates but there is no intellisense when entering the DAX and if it is added to a visualisation then the visualisation shows an error.
If a Add a measure which doesnt access that data it works fine. eg
Bonus = 500
this can be added to visualisations but is of very limited use.
In your tests is 'Salary' based on fields from the Emp Data source?
I've done some more testing following a full reboot and I'm now able to add a measure. I think the issue is a combination of needing a reboot (when I first posted the measure = 100 test didnt even work) and and that I hadn't realised that calcualted columns and measures where not the same thing in power bi.
I Will mark venal answer as accepted as following it led me to the fix.