Forum Discussion
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...
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
Super User
Super UserAnonymous Kudos means thumbs up only.
BTW, is that solution working?
Tahreem24Super User
Super UserAnonymous ,
Please verify the below Screen shot. If not correct so kindly share the expected output for Budget Phase.
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.