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 ,
Try using ALLEXCEPT.
= CALCULATE(SUM('budget'[heures prévus]),ALLEXCEPT(TableNAme,TableName[Phase Par defaut]))
NOTE: Put table name and required column name on which you want amount in ALLEXCEPT DAX function.
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
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]))