Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Created measure gets lost

Hello everyone,

I encountered with a very weird problem in Power BI desktop. I am currently using the version "2.71.5523.941 32-bit (July 2019)". I created a measure to calculate a rank in order to get my table sorted. The weird thing happening right now is my rank measure is there at the opening, but if I try to submit a change, it becomes hidden in the "Fields' pane on the most right. Since I thought I did something wrong, I created it from scratch and I got an error that saying:

 "The name 'Rank' is already used for a measure on table 'TableX'. Choose a different name."

Despite of having this message I can not see the measure in the list so I can not edit it anymore. I also tried choosing "View hidden " option, but it is not there.

Is there anyone else encountered such a problem? Could anyone have any suggestion or idea about this issue?

Thank you very much in advance,

Cheers!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Do you have another measure named "Rank"? The measure won't save on it's own if there is another measure that has that same name. Based off of the error message you posted, I would double check the other Measure names, change the name of 'Rank' to something else, and the measure should save. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey Anonymous ,

      Thanks for your reply. The thing is I have not created another rank measure on top of that. I was working on my project and suddenly this issue has arised from nowhere. I was only modifying that "Rank" measure (changing calculation from "COUNT" to "SUM") and as you said I submitted it. It was already there for ages and I was modified it before too but this time this problem happened and I do not know any solution for this and also could not find any.

      BTW I am working on a virtual machine that leads me to think it might be a memory problem, but not sure again :(

      Cheers!