Forum Discussion
Unique values
Hello Hope you can help me. The first two columns below are my data. Each client manager as a minimum capacity of clients. I need to aggregate the total by client manager but the way I have the data...
Hey Anonymous ,
first I recommend to remove duplicate rows using Power Query.
If this is not possible, then the below measure creates what you are looking for:
Measure = SUMX( VALUES( 'Table'[Client Manager] ) , CALCULATE( AVERAGE('Table'[Min capacity of Clients] ) ) )And a table visual:
Hopefully, this provides what you are looking for.
Regards,
Tom
Hey Anonymous ,
select the measure in the fields list and adjust the formatting:
Hopefully, this provides what you are looking for.Regards,
Tom
Hey Anonymous ,
first I recommend to remove duplicate rows using Power Query.
If this is not possible, then the below measure creates what you are looking for:
Measure =
SUMX(
VALUES( 'Table'[Client Manager] )
, CALCULATE( AVERAGE('Table'[Min capacity of Clients] ) )
)
And a table visual:
Hopefully, this provides what you are looking for.
Regards,
Tom