cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Markzolotoy
Super User
Super User

Remove duplicate values

I am expanding rows in a table to the right. So, what was:

Markzolotoy_0-1615668541366.png

 

became:

 

 

Markzolotoy_2-1615668595463.png

 

How can I still show a single value in my report?

 

Thanks

 

4 ACCEPTED SOLUTIONS

It depends on your data. You could use the menu "remove duplicates". Whether that is the best option depends on your data. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

I found the menu option. Not sure it would work for me. I have other rows that might have same values.

View solution in original post

Yeah, like I said, it depends your data. There is defintely a way you can do what you want to do, but it may not be the way you are currently thinking about the problem. It's impossible to know unless you share more information.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

I recommend you read this post https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1448183#M6073... 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

5 REPLIES 5

It depends on your data. You could use the menu "remove duplicates". Whether that is the best option depends on your data. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

I found the menu option. Not sure it would work for me. I have other rows that might have same values.

Yeah, like I said, it depends your data. There is defintely a way you can do what you want to do, but it may not be the way you are currently thinking about the problem. It's impossible to know unless you share more information.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Here is abit more of data:

Markzolotoy_0-1615671651940.png

I want to show totals in the report. It should be:

Servers 9

Services 42

 

Please tell me know if more detail is needed. 

 

I recommend you read this post https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1448183#M6073... 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors