Forum Discussion
iluvcoding_91
Helper I
Helper IDAX code to select 3 minimum values across matrix row, then return a concatenation of said values
Hello, thank you all for taking the time to reply to my post. I am looking for help in writing a DAX code which iterates through a matrix row and selects the top three minimum values, then returns a ...
Create a new measure as
Minimum Three = var tmpTable = { ( "Cost of living", SELECTEDVALUE('Table'[Cost of living])), ( "Housing", SELECTEDVALUE('Table'[Housing])) ... etc } return CONCATENATEX( TOPN( 3, tmpTable, [Value2], ASC), [Value1], ", ")
johnt75
Super User
Super UserJust use [Cost of living] instead of the column reference. The measures should each be calculated in the correct context from the matrix visual, so it should work
iluvcoding_91Helper I
Helper IThank you so much!!! That worked!!