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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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