add a column to say how many rows of table B are related to each row of colum A

[Anonymous]

Hello All

I have 2 tables A and B with a one to many relationshio via a key called TOKEN

(unique values on A side, duplicates on B side)

I want to add a column in table A, telling how many rows of table B are related to each row of table A

this should be easy with the folowing formula

NbRelated = COUNTROWS (RELATEDTABLE(B))

But it returns me blank values

can someone help me out ?

thanks

[parry2k]

@Anonymous can you put a sample pbix file and share it using one drive/google drive. Also, can you make sure the relationship cross filter direction is single, not both?

[Anonymous]

Thnak you for the advice

It works, with the following remarks :

I have some occurrences of TOKEN in table B which donot exist in table A, and I find them in the count 

I have occurrences of TOKEN in table A which donot exist in table B, I would expect a count = 0, which I donot find.

Can this be the explanation of the glitch ?

Thank you

[Anonymous]

f

[parry2k]

@Anonymous that should have worked, before you do this, in a table visual, put token from table a, and token column from table b and change the aggregation to count, do you get any counts against each token?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.