Forum Discussion
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...
andybamber ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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