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  : thanks for your help.

I tried what you wrote me :

Budget phase = CALCULATE(sum('public budget'[Heures prévus]), ALLEXCEPT('public financial-overview','public financial-overview'[Phase par défaut]))
 
And unfortunately i have the following : 
 

 

I don' understand why it gives me the default phasis for all the projects and not the one defined by the slicer...
 
Regards
 
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Anonymous ,

 

Please update your measure like the below:

Budget phase = CALCULATE(sum('public budget'[Heures prévus]), ALLEXCEPT('public financial-overview','public financial-overview'[Phase par défaut],'public financial-overview'[Code de Project]))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Tahreem24 thanks again for your halp.

     

    I did what you recommend, and i obtain the following erreo : 

     

     

    Where do i amke a mistake?

     

    Regards

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

      Anonymous ,

      Show me your measure. I would appreacite your KUODS/THUMBS UP.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        Budget phase = CALCULATE(sum('public budget'[Heures prévus]), ALLEXCEPT('public financial-overview','public financial-overview'[Phase par défaut]),'public financial-overview'[Code de projet])