Forum Discussion

RemiAnthonise's avatar
7 years ago

Lookupvalue / Calculate value with filters WITHOUT relationship

Hi guys,

 

I have 2 tables in my report. 1 source table called Staffel. I need "Required personnel". The Role in this table is always "VPK".

 

In my second table, I need the "Required personnel" from my first table. I want to create a way (perhaps lookupvalue or calculate values with filter.) to find the right amount of "required personnel". I (think I) need to combine / match the records of both tables. So I have matching records: start time, stop time, department code, day of the week and VPK. I only need records for role / work type VPK. How can I solve this without having relationships between tables? Besides that: in the table below I don't have a role / work type VPK. I have to make sure that the results below only give me VPK as Role or Work Type.

 

You can find my sample file here. Please see below for my results. In my sample file you'll find these tables on page 1. I expect the created measure to show me '6' as outcome.

Maybe it has something to do with the relationship between these tables. I've created an unique field in the Staffel by merging department, start time, stop time, beds open and weekday to one unique field.

I hope you guys can help me. I would really appreciate some help. Thanks!

 

edit: due to inactivity, I've opened a new topic. This one can be deleted.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    RemiAnthonise ,

     

    So I have matching records: start time, stop time, department code, day of the week and VPK. I only need records for role / work type VPK. How can I solve this without having relationships between tables? Besides that: in the table below I don't have a role / work type VPK. I have to make sure that the results below only give me VPK as Role or Work Type.

    Your sample file contains too many tables and measures. So I can't find which measure do you want to modify. Could you please explain more about the requirement above?

    Regards,

    Jimmy Tao