minimal value percountry/category with a measure

[FilipFireFlyBI]

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

[FilipFireFlyBI]

ah indeed that is an easy solution. Thanks Ahmedx!

[Ahmedx · Accepted solution]

@model = VAR _Min =[min price]
RETURN
CALCULATE(MIN('dim Models'[Model]),FILTER(ALL('fact Lease'),[Price]=_Min))