cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

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 2
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
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!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors