Forum Discussion

Serj's avatar
Serj
Frequent Visitor
3 years ago
Solved

Get column values from another table

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!

Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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, "+", "-" )
)

     

     

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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, "+", "-" )
)