Solved: Get column values from another table

Serj · ‎10-31-2022

Hi all,

I ask for your help as I am not very skillful in PowerBI so far.

I tried to make it as simple as I could. Would pls look into it?

There are 3 related tables - Application List, Application Details, and User Details.

The desired output is as follows:

Thank you in advance!

Jihwan_Kim · ‎10-31-2022

Hi,

Please check the below picture and the attached pbix file.

Condition measure: =
IF (
    HASONEVALUE ( User[User Name] ) && HASONEVALUE ( 'Application'[App Name] ),
    IF ( COUNTROWS ( Detail ) >= 1, "+", "-" )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page

Outlook Booking Schedule a short Teams meeting to discuss your question

View solution in original post

Serj · ‎10-31-2022

Thank you @Jihwan_Kim ! It works fine!

Jihwan_Kim · ‎10-31-2022

Hi,

Please check the below picture and the attached pbix file.

Condition measure: =
IF (
    HASONEVALUE ( User[User Name] ) && HASONEVALUE ( 'Application'[App Name] ),
    IF ( COUNTROWS ( Detail ) >= 1, "+", "-" )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page

Outlook Booking Schedule a short Teams meeting to discuss your question