Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
AMYYC
New Member

Split rows with same id

Hi all,

 

I am new to Power Bi and have a problem. I have excel data with id keys and item inventory, but when I bring the columns into the Table visual Power Bi is combining the same id keys together into a single row. 

 

I need to be able to do calculations for specific conditions but with everything combined I cannot figure out how. Is there a way to separate these rows so I can get all the same ids individual. If not can someone work with me to make a measure calculation?

1 ACCEPTED SOLUTION
v-kkf-msft
Community Support
Community Support

Hi @AMYYC ,

 

The Power BI visuals don't display duplicate rows. If you want to display all unaggregated rows in the visual, you can add the index column in the Power Query Editor, then close and apply the changes. Then select "Don't summarize" for the fields in the visual.

 

image.pngimage.png

 

If you just want to add a column to calculate the value greater than 300 as 2, then you can try the following calculated column.

 

Column = IF( 'Table'[item inventory] > 300, 2 )

image.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

6 REPLIES 6
v-kkf-msft
Community Support
Community Support

Hi @AMYYC ,

 

The Power BI visuals don't display duplicate rows. If you want to display all unaggregated rows in the visual, you can add the index column in the Power Query Editor, then close and apply the changes. Then select "Don't summarize" for the fields in the visual.

 

image.pngimage.png

 

If you just want to add a column to calculate the value greater than 300 as 2, then you can try the following calculated column.

 

Column = IF( 'Table'[item inventory] > 300, 2 )

image.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

ryan_mayu
Super User
Super User

@AMYYC 

have you tried 'Don't Summarzie'?

1.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I have tried No Summarize and it did changed the values, but the ids were still combined.

@AMYYC 

could you pls provide some sample data and expected output?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ummmm, eek, that will be hard. Let me see if I can repo the problem with some dummy data. 

Is there a way to maybe do the calculation I need at the Raw Data model level? I tried a custom column but it does not appear to support IF statements.

Ultimately I want to just evaluate the items and if they are greater than 300 set a value of 2.

@AMYYC 

since I didn't see any screenshot or your data, it's a little hard to understand your question and provide the proper solution

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.