Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

calculate with text filter

Hello,   I have two linked tables :    The first one :    For each Projects code, "phase par défaut" is unique.   I have the second one called budget, contains an amount of hour per pha...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous ,

    So here you go:

    Budget phase = CALCULATE(sum('public budget'[Heures prévus]),FILTER('public budget','public budget'[Phase de projet]=RELATED('public financial-overview'[Phase par défaut])))
     
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Anonymous ,

Validate the below Screen shot:

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Tahreem24 : yes this is the correct answer 😀

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Tahreem24 !! Yeah it works!!

     

    Thanks for your patience...if i could i'll give you a thousand of kudos :-).

     

    Kind regards,

    Michael

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

    So here you go:

    Budget phase = CALCULATE(sum('public budget'[Heures prévus]),FILTER('public budget','public budget'[Phase de projet]=RELATED('public financial-overview'[Phase par défaut])))
     
  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Perfecta y buena suerte Anonymous !

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Anonymous  Kindly mark my post as a solution.

    GOOD LUCK!!!