Return text value based on index number

[ikarouscb]

Hello Everybody 

i need your help, probably its more simple than i thought but i have tried diferent things with no success

i have a table of information, where the "Database downloaded",  adds in a column the report creation parameters,

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

i was trying to use this measure for it, but it only returns Blank result

Manit Time = MAXX(

                FILTER('Manit',Manit[Índice] = 1),

                Manit[Created]

[nandic · Accepted solution]

@ikarouscb 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)

Cheers,
Nemanja Andic

[ikarouscb · Accepted solution]

Thank you very much @nandic this really work!!, one minor issue (i can live with ) is that when the data segmentatio filter selects something, it goes back to the blank value, is there any easy way to mantain that creation value no mater the segmentation filter data?

[nandic · Accepted solution]

@ikarouscb 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)

Cheers,
Nemanja Andic