Measure to RETURN a with different conditions, based on other Measures

[Buggi]

Hello Community, 

I already received amazing help from you guys, thank your for that.

The formulas i found here helped to make big improvements within my future PI Database.

Now i reached a limit. 

Here the status of what i did first.

Measure 1:

Calculates the average number of transactions of the last three months and then looks up which package the client should have and returns the product name.

Measure 2:

Does the exact same thing with the difference that it returns the Fee based on the average number of transactions of the last three months.

Measure 3: 

Looks up the number of employees of the last month and based on this finds the right package, based on a range of employees and returns the necessary product for the client.

Measure 4: 

Does the same thing as Measure 3 it only returns the fee instead of the product name.

So now i need a measure for tax services.

Our tax services depend either on the accounting package or on the payroll package, which ever is bigger, the tax package follows. 

I have a service table that looks like this:

Above is the Excel Table linked to Power BI.

To clarify,

If a client ends up getting with Measure 1 the produce Accounting Package 3

And from Measure 3 Payroll Package 6, then it should end up in returning Tax Package 06, as tax always follows the bigger package within Accounting and Payroll. I also added the service code at the end of the table, as i thought it might could be used to compare these numbers easily within the numbers. 

I do not need this service code, but i have absolutely no idea how to achieve that.

I hope i could explain it properly. Its quite complicated, at least from my perspective.

[v-zhangti]

Hi, @Buggi 

The data you provided is not very clear, especially for several identical column names. Please provide the completed column names.

What is the expected result you want? Is there a picture description? Please provide more details. Thank you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.