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])))
     
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Tahreem24 : what i am expecting to have is the following :

 

For each project code, there is a current phasis (contained in field "phase par défaut" in "Public financial-overview" table.

In the table "Budget", i have to sum "Heures prévus" for each row whare the field "phase de projet" is equal to "phase par défaut".

So doing like this, i have the budget in hours for the current phasis of the project.

 

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 😀

    • 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])))
       
      • 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