Avoiding the "first" that automatically Power Bi assigns...

[Anonymous]

I have a Clients table, with columns:

-Name

-Number

-Parent

-Parent Number

-Owner

Whenever a client has same Parent as itself, for example:

********

-Name: Client xyzz

-Number: 12345

-Parent: Client xyzz

-Parent Number: 12345

-Owner: John

********

It means that it has no parent. (or that the parent is itself...)

My problem comes when using a Matrix in Power BI…

In Rows I have

• Parent
• Name

When I choose Owner for Values… 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?

(screenshot for reference)

(I guess the model is not ideal, but I would like to fix it with a measure or a calculated column).

[Anonymous]

Add this to the list of a thousand reasons why Power BI is **bleep**.

[amitchandak]

@Anonymous , Anything in values will have aggeration even if you have a unique value for row combination.

If you do not want that, move to rows

[Anonymous]

Thanks for your ansewr but I need it as a separate column.

[v-easonf-msft · Accepted solution]

Hi,  @Anonymous 

This is the default behavior of matrix and only depends on the type of data you put in the "Value".

If you put a text field in "value", the aggregation could only be "first", "last", "count"...
If you put in a numeric field , the aggregation could only be "sum", "average", "max"...

As a workaroud ,you can  put all field "Parent","Name","Owner" in Rows.

Then close the option of "Stepped layout".

The result will show as below:

Best Regards,
Community Support Team _ Eason