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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Polo87
Frequent Visitor

Splitting columns result in duplicated rows which cause to wrong Count number

Hello all,

 

I am struggling with problem when I try to split column By Delimiter to rows. I have one table for now.

I am trying to split Labels (and sub-scope also) column to use solo values in slicer but when I am doing it I am getting duplicated rows with other columns.

I mean when I split labels column and then I try to use Count of Market I am getting 6 instead of correct value in this case which is 3.

I would like to do split also for Sub-scope but It causes additional rows and also getting wrong values in Market count or Sum of TCV etc.

 

How to work with it to split these valus to use it in slicer and be able to filter with this slice all needed visuals but do not cause duplicats and wrong count/sum numbers?

Quick example on screenshot

Polo87_0-1709294450723.png

Thanks in advance

1 ACCEPTED SOLUTION

I hope you have created relationship between the 2 tables too. If you are unable to do it, please share the sample pbix file here.

View solution in original post

5 REPLIES 5
miTutorials
Super User
Super User

Create Primary key and Copy the Primary key and Labels to a new table and then split the values. You can use a measure to count the Market column from your main table.

 

Regards

Ismail 

@miTutorials  Could you write it in more details? How to create Primary key and copy it to another table?
In that solution I can split labels and sub-scope in one newely created table ?

 

Edit -  I was able to find in model view how to set Key Column(This is such option, right?)

However I don't know how to copy it to new Table. I should set Primary key there also?

Polo87
Frequent Visitor

I set Key Column, Duplicate table and split values but When I put slicer with Values from new table there is no effect on visuals which use values from primary table

I hope you have created relationship between the 2 tables too. If you are unable to do it, please share the sample pbix file here.

After setting relationship "one to many" works as expected.
Thanks

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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