How to show SelectedValue in a new column of table?

[justin1102]

Hi,

I have 3 tables Sheet1, ChildTable and ChildTable2. I have insert a new column in ChildTable called "ValueSelected". The value in "ValueSelected" in ChildTable I want be SELECTEDVALUE(ChildTable2[Date].[Day]). But, when i selected the ChildTable2[Date].[Day]. The value in ChildTable would not changed, it is empty. 

May I ask why and how to solve this?

Please any expert help me to solve this!

[joaoribeiro]

Hi @justin1102 , please consider using the LOOKUPVALUE function to search the desired column from the ChidlTable2, or use the RELATED function to indicate to Power BI that the tables have a indirect relationship.

https://learn.microsoft.com/pt-br/dax/lookupvalue-function-dax
https://learn.microsoft.com/pt-br/dax/related-function-dax

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!

Best regards,
Joao Ribeiro

[justin1102]

@joaoribeiro 

Hi, thanks for replying! Based on the image below, my expected result want to be "Day" value and insert it into "LatestDate" column based on the row that i clicked in the table below. Example, I clicked "Day" = 2 in table below, then the every row of "LatestDate" should be 2.

Note: The above Table is ChildTable and below table is ChildTable2

[joaoribeiro]

@justin1102 consider using the following formula for a new Calculated Field:

LatestDate = 
VAR SOID = (ChildTable[SOID])

VAR Result = 
    CALCULATE(
        MAX(ChildTable2[Day]),
        ChildTable2[SOID] = SOID,
        ALL(ChildTable2[Day])
    )

RETURN Result

Example of result:

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!

Best regards,
Joao Ribeiro