Hi ninjas!
In Power BI I have a data model composed of the following tables
A goals table called "fMetas" which contains the following fields:
'Date' (period to which the target refers),
'Cod RCA' (seller code),
'RCA Name' (seller name),
'Line Code' (product line code),
'Line' (name of the product line),
'Meta Value' (seller's target value)
A table called "dClientes" that basically works as a portfolio of customers and their respective responsible sellers. This table contains the fields:
'Customer Code' (customer code),
'Customer Name' (customer name),
'Cod RCA2' (1st seller's code),
'RCA2 name' (name of the 1st seller),
'Cod RCA3' (2nd seller's code),
'RCA3 name' (name of 2nd seller),
'RCA2 Key' (key that concatenates the 1st seller's code with the customer's code),
'RCA3 Key' (key that concatenates the 2nd seller's code with the customer's code).
A table called "dClientes (Aux)". This table is an auxiliary table for the "dClientes" table.
This table contains the following fields:
'Cod RCA (seller code),
'RCA name (seller name),
'Customer Code' (customer code),
'_Key' (key that concatenates the seller's code with the customer's code)
The fields 'Cod RCA2' and 'Cod RCA3' in the "dClientes" table are related to the 'Cod RCA' field in the "fMetas" table.
The '_Key' field in the "dClientes (Aux)" table is related to the 'RCA2 Key' and 'RCA3 Key' fields in the "dClientes" table
I intend to use the 'RCA Name' field from the "dClientes (Aux)" table as a data segmenter.
I intend to use the field 'Name RCA2' and 'Name RCA3' from the "dClientes" table in visuals such as graphs and tables.
I need a DAX measure that calculates the RCA2 and RCA3 target.
I need the filter direction to follow the flow "dClientes (Aux)" > "dClientes" > "fMetas", because when I figure out how to do this I will break the RCA goal to its respective clients.
