Return text value based on index number

Question

Hello Everybody&nbsp;&nbsp;i need your help, probably its more simple than i thought but i have tried diferent things with no success&nbsp;i have a table of information, where the "Database downloaded",&nbsp; adds in a column the report creation parameters,&nbsp;&nbsp;&nbsp;i just want to copy the first row text value with index no 1 into a measure so i can add it into a card so everybody can see it when they are analysing the dashboard&nbsp;&nbsp;i was trying to use this measure for it, but it only returns Blank result&nbsp;Manit Time = MAXX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER('Manit',Manit[Índice] = 1),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Manit[Created]&nbsp;

nandic · Accepted Answer

ikarouscb&nbsp;try using this formula for measure:Text = CALCULATE(MIN(Table_Row[Created]),Table_Row[Indice]=1)And this is even better because even if you filter out indice 1 on report, it will always show data:Text = CALCULATE(MIN(Table_Row[Created]),ALL(Table_Row),Table_Row[Indice]=1)&nbsp;Cheers,Nemanja Andic

Forum Discussion

Return text value based on index number

2 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

FORMAT() returns Month Number

MAXX Returning duplicate values

Return "Specific value" from table 1, if not found, return value from table 2