Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I've got quite a number of different sets of data which all need to be presented with some percentages, totals etc, which requires measures. I try to name them as "%", "Total" but I am only allowed to use it once as their names have to be unique. Is there any tricks to overcome this?
Thanks in advance.
Michael
Solved! Go to Solution.
Hello Mickael
I think there is no way to bypass this limitation.
But I think this limitation, is not really a technical one, it more functional. Keep in mind that each measure should represent a business item, and if the data is different, so the name must clearly explicit what it means, and so be different too.
If all of you objects have the same name, but different functional purposes, the end-user may have difficults to understand the meaning of each one. If they don't understand the meaning, they will said that you report is wrong.
This is not a matter of technic, this is a matter or business metric. For example, the total amount and the total of customer, may be named this the same "total" label. But when you use it, how would you identify one item from the other?
Hope it helps you
Sébastien
Hi @operator,
I'm totally agree with @Anonymous. Observe that if in the same .pbix file you have multiple measures you can use one of them in all the tables that you have attached to the .pbix file. So you must have different names.
But if you want to overcome this limitation, or generalize the measures I suggest you to set the measure name to something like:
"%_nameOfTheSetOfData"
"Total_nameOfTheSetOfData"
Hello Mickael
I think there is no way to bypass this limitation.
But I think this limitation, is not really a technical one, it more functional. Keep in mind that each measure should represent a business item, and if the data is different, so the name must clearly explicit what it means, and so be different too.
If all of you objects have the same name, but different functional purposes, the end-user may have difficults to understand the meaning of each one. If they don't understand the meaning, they will said that you report is wrong.
This is not a matter of technic, this is a matter or business metric. For example, the total amount and the total of customer, may be named this the same "total" label. But when you use it, how would you identify one item from the other?
Hope it helps you
Sébastien
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
45 |