Trying to select one columns value based on another column value in same table

Hi Jihwan_Kim

Thank you !  

Adding EVALUATE did the trick and the code below now executes from DAX Query View inside the powerbi file. It will select the rows in [column1] where the value in [column2] has the text value of  "fgh"  .

EVALUATE
CALCULATETABLE (
SELECTCOLUMNS ( Table1, Table1[column1] ),  Table1[column2] = "fgh"
)

I investigated further on how to create a temp table ( dynamic table ) using the same code. 

To do this I opened up Table View, pasted in the following and clicked the green tick ( note that the EVALUATE function is removed for this step ) :

Temp_Table1 =

CALCULATETABLE (

SELECTCOLUMNS ( Table1,  "Test_Column1",  Table1[column1] ),  Table1[column2] = "fgh"

)

 

 

This then creates a temp/dynamic table called Temp_table1 with column called "Test_Column1" you should see appear in thepowerbi  Data  pane. 

 

 

To confirm everything was all working, I then went to the Report View in powerbi, found the Temp_Table1 and dragged the Test_Column1 into the report area, and it accurately showed the contents of the column as expected.

 

 

Kudos for this.

 

 

 ------------------------

Subject :    Trying to select one columns value based on another column value in same table

 

Keywords   DAX  powerbi temp table dynamic table column value select into