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.
Hi all,
I have a small example table (left). It contains per country/category all available models with the according annual price.
I want a matrix table (result table) using measures with the minimum price (min price) per Country Category. This I already created succesfully.
Now I also want to show in a Measure (no calc. column or seperate summarize table!) the Model that is corresponding to to this minimal annual price (see Yellow part). So for Country BE with Category A, the cheapes price is 579 and this is model A4.
See below the dropbox link for the PBIX file.
Thanks in advance!
https://www.dropbox.com/s/uerqf5i2xf61lkv/Minimum%20value%20per%20category.pbix?dl=0
Solved! Go to Solution.
@model = VAR _Min =[min price]
RETURN
CALCULATE(MIN('dim Models'[Model]),FILTER(ALL('fact Lease'),[Price]=_Min))
ah indeed that is an easy solution. Thanks Ahmedx!
@model = VAR _Min =[min price]
RETURN
CALCULATE(MIN('dim Models'[Model]),FILTER(ALL('fact Lease'),[Price]=_Min))
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |