Calculation / Measure

Hi,

You have a problem of relationship.

Some of your relationship seems to be inactive (those with dash lines not continuous lines).

Right clic on them to activate them.

If you're unable to activate them, maybe you should use
the CROSSFILTER function in your measure to calculate Targets amount.

To give you an example :

Mesu Montant Compte = CALCULATE(
SUM(TabMontant[MontantCompte]); 
CROSSFILTER(
'Client-Compte'[NumCompte];TabMontant[NumCompte]; //Columns to link (relation)
Both)) //Direction of relation

Hope it helps

Hi,

Depends on how many Salesmen you have to deal with.

With a few the IF function will be fine,

if you have more than a few I'll suggest to use SWITCH (link to one example)

If you have a lot, then the best would be a table with sales men and their team, and link this table to your sales fact.

Have a nice day, and do not hesitate if you need more explanation