I have a table below from which i'd like to show the cheapest supplier presented on a card. The expected answer is just "A" because the price is "1"
However, the result I get is "A , A". I am using the measure
1lowest price = CONCATENATEX(TOPN ( 1, 'table',[price], ASC ), 'table'[Supplier], ", ")I wish to only see "A" once, as in only 1 supplier even if there are more than 2 suppliers with the lowest price.
Solved! Go to Solution.