I have a Clients table, with columns:
- Parent Number
Whenever a client has same Parent as itself,for example:
- Name: Client 1
- Number: 12345
- Parent: Client 1
- Parent Number: 12345
- Owner: xyz
It means that it has no parent.
My problem comes when using a Matrix in Power BI…
In Rows I have
I understand that since its grouping by, it just picks the first value… but the row does have a value, how can I force to select the owner?
(I guess the model is not ideal, but I would like to fix it with a measure or a calculated column).