Forum Discussion

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

Logical Measure Using 3 Tables

Hello Community!   I'm not sure this is even possible... So I have 3 tables... a user table which has a relationship to an organisational hierarchy table using the user_id, the organisation table i...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

andybamber ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • andybamber's avatar
    andybamber
    Icon for Helper III rankHelper III
    5 years ago

    Hi There! thanks for the quick response... i've attached an Excel which hopefully illustrates my issue

     

    User table joined to Org on User_Id, and then Org joined to CC on OBS_Key... i need to look at the user_id (this table also contains full name) and if the CC contains DE then the measure needs to show something like "xx, xx", else actual name "Bamber, A"

     

    Cheers

     

    Andy

  • andybamber's avatar
    andybamber
    Icon for Helper III rankHelper III
    5 years ago

    Hi There! just wondering if you managed to find a solutiuon for this?

     

    Cheers

     

    Andy