Problem with formula

[AlexGallet01]

Hello,

I don't understand why i don't do this.

Représentant choisi = SELECTEDVALUE('Représentant'[Personnalisé])

Test = CALCULATE(SUM(Factures[Representant €]);Factures[Représentant 2]=[Représentant choisi])

Reguards.

[AlexGallet01]

I have another problem in rapport with this.

My representant have a link with rep01 but if i want to have the order with rep02 = representant i need to create a link with rep02 but it's not possible to create a link if he has another link.

So how i can to create 2 active links ?? 

[vcastello]

Hi @AlexGallet01

You can have two links, although only one can be active at a the same time.

If you want to use the inactive relationship, you can use the USERELATIONSHIP function

Check

https://msdn.microsoft.com/en-us/library/hh230952.aspx

[vcastello]

Hi @AlexGallet01

Try ...

Test = CALCULATE(SUM(Factures[Representant €]);Factures[Représentant 2]=VALUES([Représentant choisi]))

[AlexGallet01]

Hello,

When i try this my Représentant choisi not accessible

[vcastello]

Is there a relationship between 

1.- Table "Factures"

2.- Table "Représentant"

Possibly through Factures[Représentant 2] and Représentant[Personnalisé]
?

If so, a simple

CALCULATE(SUM(Factures[Representant €]))

should work for you

[AlexGallet01]

Hello,

I try a new measure. 

Représentant 2 € = CALCULATE(SUM(Factures[Representant €]);FILTER(Factures;Factures[Représentant 2]=[Représentant choisi]&&Factures[Représentant 1]<>[Représentant choisi]))

But now i don't have results while i do have results.