Help with a measure to count values of table

cmsystems42 — Fri, 01 Dec 2023 14:31:15 GMT

Table 1

ID	Name
1	Orange
2	Blue
3	Black
4	Green

Table 2

ID	Location	Name	NameId
1	Atlanta	Blue	2
2	Rome	Blue	2
3	London	Black	3
4	Paris	Orange	1

Table 1 have a 1 to many relationship with Table 2. I want to create a measure to count the rows for each name to have a total of each name that is valued in Table 2. Then I want to identify how many names have 1 or less rows in Table 2.

Thank you for any help you can provide!

Re: Help with a measure to count values of table

lbendlin — Sun, 03 Dec 2023 01:00:34 GMT

Why a many-to-many relationship? The colors are unique.

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

topic Help with a measure to count values of table in DAX Commands and Tips

Help with a measure to count values of table

Re: Help with a measure to count values of table