Forum Discussion
Super UserMeasure not existing in semantic model/report level
I am experiencing a weird behavior.
I have a report connected to a semantic model published on a workspace (I am using live connection).
There is a measure used in a visual in the report.
When I try to check it on the report level it is a greyed out I can't check the DAX code but I still find it in the Data section.
When I go back to the semantic model, which is based on data coming from SQL Server (using import) I can't find it.
What am I missing ?
3 Replies
Maybe this is a report level measure
i.e. This measure was created and exists only on this report, and not on the semantic model. The recommended would be to recreate the measure on the semantic model and republish it, if you wish to reuse this measure in multiple reports.- AmiraBedh
When I open the report on PBI Desktop, the measure is also greyed out.
Hi AmiraBedh ,
Try going to the workspace like this to find the associated semantic model and download the pbix file to open it on the PBI desktop, can you find that measure?
Solved: I get no option to edit a measure, is there any wa...
Sometimes the semantic model being connected references other semantic models as well, and we still won't be able to see the measure code and will need to keep looking upstream. Please double check that the data source for the semantic model being connected is only a SQL Server database in import mode?
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
