Data Exploding when adding a measure to a table

[JDavies23]

Hi All,

Please see below simplified PBIX showing the issue I am facing.

Exploding Table.pbix (20.2 KB)

I have two tables, with the example extracting [ID] and [REG] from the Parent table and [ID] and [TEXT] coming from the child table. As you can see from the below, the relationship is identifying the two [ID] columns and joining them as expected.

However, When I go to add a measure to the table, the data explodes showing repeating data from the parent table, as shown below:-

Any help in preventing this from happening is appreciated.

Thanks.

[Yashh]

Hello @JDavies23 

Try using slicer for Text. as shown in the picture.

Best regards

Yashh 

If you find this usefule please give kudoos and mark it as solution if I answered your question.

[JDavies23]

Hi, 

Thanks for your response, however, the desired outcome would be that when I bring [Units] in to the table, I would have '1' at the end of every row where applicible (Not ID 5). 

ID	REG	ID	TEXT	Units
1	aaa	1	Line1	1
1	aaa	1	Line2	1
1	aaa	1	Line3	1
2	bbb	2	Line1	1
2	bbb	2	Line2	1
3	ccc	3	Line1	1
4	ddd	4	Line1	1
5	eee

On your example, I would be missing the rows with 'Line2' and 'Line3', which I want to be showing.

Hope that makes sense.

Thanks