How to fix pbix forcing to "First value" of a column when using matrix?

Anonymous — Wed, 21 Jul 2021 10:43:46 GMT

I have a Clients table, with columns:

-Name

-Number

-Parent

-Parent Number

-Owner

Whenever a client has same Parent as itself…:

********

-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

Parent
Name

When I choose Owner… automatically, it creates this “First Owner” and picks a “wrong” value…

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).

Re: How to fix pbix forcing to "First value" of a column when using matrix?

Anonymous — Thu, 22 Jul 2021 11:26:48 GMT

If something has no parent, then it should not have a parent. Period. That means you should massage your data in Power Query and remove the reference to itself and replace it with either BLANKS or---much better---create a dummy parent and have all those items that do not have a parent reference this dummy member of the dimension. This is how you do it professionally following the best practices of dimensional design.

topic Re: How to fix pbix forcing to "First value" of a column when using matrix? in DAX Commands and Tips

How to fix pbix forcing to "First value" of a column when using matrix?

Re: How to fix pbix forcing to "First value" of a column when using matrix?