Forum Discussion

gdecome's avatar
gdecome
Icon for Helper III rankHelper III
5 years ago
Solved

Getting values and filtering a virtual table

Hi all, I need to create a table inside the measure (not as another table) and get values from there.  If I run as below, it works fine     I see the table is Ok   How to write an e...
DATATABLE
DAX
  • amitchandak's avatar
    amitchandak
    5 years ago

    gdecome , You can try like

    MAXX(_index,_index[Value2]))

     

    MAXX(filter(_index,_index[Value2] =2),_index[Value3])

     

    You have use functions which take table name as one of the argument

     

gdecome's avatar
gdecome
Icon for Helper III rankHelper III
5 years ago

Thanks amitchandak but it is not working yet. It is not recognizing the table

 

 

gdecome's avatar
gdecome
Icon for Helper III rankHelper III
5 years ago

Hi amitchandak , I could solve the problem removing the table name before the column name.

MAXX ( _index , [Value2] )
Thank you for your help