Help with creating a DAX measure based off of MDX

[SRobbo1990]

Hi All,

I am in the process of creating a measure that has already been created in MDX some time ago but works. The measure is as below;

(
[Measures].[Count of Trips],

LinkMember ([Enquiry Date].[Year-Quarter-Month-Date].currentmember, [Departure Date].[Year-Quarter-Month-Date] )
, [Enquiry Date].[Year-Quarter-Month-Date].[All]

,LinkMember ([Booking Employment Structure].[Full Name].Currentmember, [Employment Structure].[Full Name])
, [Booking Employment Structure].[Full Name].[All]

,LinkMember ([Booking Employment Structure].[Job Title].Currentmember, [Employment Structure].[Job Title])
, [Booking Employment Structure].[Job Title].[All]

, [Trip Workflow].[Workflow].[Workflow Step].&[3.Booking]
, [Cancellation Date].[Year-Quarter-Month-Date].[Year].&
)

So background as to what this is trying to do - I have two tables that are identical, Employment structure and Booking Employment structure. They each have a relationship to a single fact table called Trip. My organisation want to get a count of trips at each stage of the booking process using the Booking Employment Structure but wish to see a count of departures using the employment strucutre. I believe I need to use USERELATIONSHIP somewhere but am struggling to replicate the above in the test scenario. Below is a view of the table so far;

As you can see I'm using the Booking Employment structure[Full Name] in the table and need to create a measure to include another value using the Employment Strucutre[Full Name] in the table.

Hope that makes sense and thanks in advance

[amitchandak]

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

See if this blog can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[SRobbo1990 · Accepted solution]

Hi there,

In the end I was able to figure out the issue using the TREATAS funciton