Measure is invisible in excel Power Pivot

[DataNinja777]

Hello Power BI community,

I have a problem from today that measures are invisible in the Excel power pivot data model.  Is this a bug, or did I click somewhere I shouldn't which hides measures from the deta model for security reasons?  

Please let me know how I can fix the problem.  

Thank you very much for your help.  

[Fowmy · Accepted solution]

@DataNinja777 

Click on on Show Hidden Button on the Home Tab, under views. then right on the greyed meaure and select "unhide from client tool"

[Fowmy]

@DataNinja777 

Did it work?, 

[DataNinja777]

Hi @Fowmy 

Thank you for your follow up.  

Actually, my problem was more strange than the usual case you pointed out.  There's not even a gray invisibility and nothing was visible.  In your screen print, I can see the gray visibility, but my case was that I couldn't see anything at all.  After closing and reopening the file, and the unticking and ticking Power Pivot in Com add-in, it didn't fix the problem, but when I changed the measure formula, it became visible.  I still don't know what was the issue.