Forum Discussion

ikarouscb's avatar
ikarouscb
Frequent Visitor
2 years ago
Solved

Return text value based on index number

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",  ad...
Need Help
  • nandic's avatar
    nandic
    2 years ago

    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's avatar
    ikarouscb
    2 years ago

    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's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
2 years ago

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