Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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 ...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |