measure that displays only the amount of the largest suppliers for each client

[Anonymous]

Good afternoon, dear friends, I need to calculate a measure that displays only the amount of the largest suppliers for each client.

1. first group the sales table by customers of its suppliers and the sales amounts for each customer.
2. from the table of paragraph 1, select the largest amounts of sales for each supplier and the supplier itself
3. make a measure that when creating a list of suppliers showed the amount by which it is large for each supplier

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Assuming that the second table is your data sample ang the third table is your expected, then you could create the two measures below to achieve your desired output.

Measure =
CALCULATE (
    MAX ( 'Table2'[Amount] ),
    ALLEXCEPT ( Table2, 'Table2'[Supplier], 'Table2'[Customer] )
)

Supp = LOOKUPVALUE('Table2'[Supplier],'Table2'[Amount],[Measure])

Here is the output.

Best  Regards,

Cherry

[Anonymous]

Hello v-piga-msft !!!

and how to immediately make measures from the first table, without grouping the totals in the table two, while the amount of sales was all for the period?

I tried to do through summarize and then through MAXX, but the result is wrong?

I do not want to use a physical table in the model because I need a dynamic measure ...