Forum Discussion

andybamber's avatar
andybamber
Helper 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 in turn has a relationship to a cost centre table using an obs_ref key. There isnt any key to link the user table direct to the organisational table.

 

What I would like to be able to do is create a measure which looks at the user in the user table, and if that user's cost centre has specific characters in the string it will create a value "xxx, xx"... essentially its masking the users name depending which cost centre they are in...

 

I could do some merging in power query and then add a custom column etc. but I was wondering if dax could handle this in a measure?

 

Cheers

Andy

3 Replies

  • amitchandak's avatar
    amitchandak
    Super 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
      Helper 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
      Helper III
      5 years ago

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

       

      Cheers

       

      Andy