Get table to aggregate in power BI

Dales91 0
Viewed 40

I am sure this is really easy to do but could some one tell me what I am doing wrong.

I have this table enter image description here

When I add a new measure to do Target -Total Amount I get additional lines.

enter image description here

How do I remove these so it is aggregates?

reference for relationships Salesperson is the same as Employee name enter image description here

dax powerbi
2 Answers

This is due to absence of some 'Sales person' in 'Sales Transaction'.[Saleseperons] Change 'Sales Transaction'.[Saleseperons] to 'Sales person]'.Name in the matrix

userLOTh10

Try to wrap your calculation in a CALCULATE().

usergIl710
Related