Forum Discussion

singh_gagan03's avatar
singh_gagan03
Frequent Visitor
5 years ago

DAX Requirement || Help

Hi All,   I am facing a problem in writing DAX for the scenario explained below, need help asap. The Data Source is Excel Worksheet.   Visuals on page: 2 slicers (country and item) and matrix vis...
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

singh_gagan03 

Min Price=CALCULATE(MIN(Table[Price]),ALLEXCEPT(Table,Table[Item]),ALLSELECTED(Table[Country]))

Country With Min Price=CONCATENATEX(TOPN(1,CALCULATETABLE(Table,ALLEXCEPT(Table,Table[Item]),ALLSELECTED(Table[Country])),CALCULATE(MIN(Table[Price])),ASC),Table[Country],",")

singh_gagan03's avatar
singh_gagan03
Frequent Visitor
5 years ago

HI wdx223_Daniel ,

 

I have implemented the min price DAX but the result I am getting is not aligned as per the image I shared with you. The DAX you have shared with me is giving me the minimum value as same across slicer selections.

 

For example in scenario 1 the DAX for Item 1 it is returning me min price as 33.33 and country as C1 for all selections which are correct but when I make the selection as Country = C2, C3 then the min price should be 100, and the country now be C2.