Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
8 years ago

Problem with formula

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.

Need Help

6 Replies

  • vcastello's avatar
    vcastello
    Resolver III
    8 years ago

    Hi AlexGallet01

     

    Try ...

     

     

     

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

    • AlexGallet01's avatar
      AlexGallet01
      Helper IV
      8 years ago

      Hello,

       

      When i try this my Représentant choisi not accessible

      • vcastello's avatar
        vcastello
        Resolver III
        8 years ago

        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's avatar
    AlexGallet01
    Helper IV
    8 years ago

    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 ??