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  Kudos means thumbs up only.

BTW, is that solution working?

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

    Anonymous ,

    Please verify the below Screen shot. If not correct so kindly share the expected output for Budget Phase.

     

    • 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: