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 ,

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

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

    Perfecta y buena suerte Anonymous !