Max value from a measure shown on each row

[1up]

Hi,

With measure [Max Market Share] I want to display the maximum Market Share available in measure [Market Share]. Market share exist for every Customer in table: Customer.

With different tries with the Maxx function, ALLSELECTED etc. I have so far been unsuccessful. I always get the related row's market share to show again instead of the maximum market share being shown for all rows in the table.

Example of wanted functionality:

Table: Customer

Customer | Market Share | Market Share Max   

A                10%                  50%

B                 50%                 50%

C                 3%                   50%

Result I have gotten so far which is not wanted:

Table: Customer

Customer | Market Share | Market Share Max   

A                10%                  10%

B                 50%                 50%

C                 3%                   3%

Thanks for help,

Daniel

[1up]

Thanks for the reply, I got still however get the row-values for all rows, instead of the max value market share for each row. Market share is just existing in a measure, I was incorrect in writing market share exist in the Customer-Table.

Further suggestions would be helpful.

[vicky_]

It seems that you just need to remove the filter from the customer row. In this case, try something like:
Max Market Share = CALCULATE(MAX(Customers[Market Share]), REMOVEFILTERS(Customers[Customer]))