Need to assign measures to a table but cannot find the measure in the search box

[JohnYEG]

Hello, 

I get this this error.

It shows I have a measure called "BD - Opportunities Won - Under Contract". When I type in to search for it, I do not see it.

I have tried looking for the other measures as well and I cannot see them. Is there another place I can look?

Thank you

[Anonymous]

There are two possible solutions for this issue that I am aware of.

1. In the right hand "Data" pane, click on the more options ("...") for any one table and ensure that "view hidden" is checked.

2. On the left hand side go to the "model view" tab. The missing measures will show up in the data pane as hidden tables. Alternatively, they will also be among the tables as a card visual (scroll from left to right and they are easy to identify with the warning sign next to the metrics) click on the measures to expand them in the data pane. Drag the measures to the new tables within the right hand data pane.

 

Hope this helps resolve your issue!

[arodell]

Did you ever figure this one out? I'm running into the same issue when trying to covert to direct query, the measures the error mentions don't seem to exist in my file.