Value position

[Anonymous]

Hi Team,

I have to pick specific value in the below tbl, please look into this.

Please help on DAX formula.

Thanks,

KV's

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

You may go to 'Query Editor', create an index column as below and then click 'Close and Apply'. The pbix file is attached in the end.

You may create a measure as below.

Result = LOOKUPVALUE('Table'[Perentile],'Table'[Index],4)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not very clear.

Try a measure like

CALCUALTE(max(Table[percentile]), filter(Table, table[Grade]= "IV"))