Getting Duplicate Values

[Anonymous]

Hi, 

I have a problem that when an item has different reference numbers it duplicates the values. Is there a way to make it just show the values for one reference number or to show the reference number in different way? I am working with a matrix, I already tried with a table and it gives me the same problem. Attached is an image of the problem.

Thank you,

RC

[JarroVGIT]

Well, what reference number would you like Power BI to show you? It won't randomly decide which is the one you want to show so it shows them all.

If you want to show only 1 reference number, you couldcreate a measure that finds the first (or last) referencenumber of a given item and then that one is shown, is that suitable for you? In that case, sample data would help in creating that measure for you. Then you can create a table with [Item] - [Measure] - [otherColumnRelatedToItem] etc.

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂

[Anonymous]

Hi, thank you for your response. While that would be the best solution for now, do you know if there is a way where I can show all reference numbers and split the value between them or show the value for one reference number and not for the rest?

Thanks,
RC

[JarroVGIT]

I am not sure what you mean, could you post your data structure and some sample data and an example (e.g. from Excel) of what your expected outcome is?