calculate with text filter

[mhendel]

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 phasis.

Tables are linked by code de projet and i have a slicer with that code.

I have to extract the amount of hours for the default phasis, with a measure.  

Someting like : budget current phasis = calculate(SUM('budget'[heures prévus]),(a filter to find what i want"))

My problem is that i can't find the way to filter that...

Can you help me ?

Thanks!

[negi007]

@mhendel  If your problem still not resolved would apprecite if you could share your powerbi file.

[mhendel]

https://drive.google.com/drive/folders/1J8l7Ahx0m7ZXlAMMKAhFu4MDN9L9FljO?usp=sharing

Here is the file

[Tahreem24]

@mhendel  Kudos means thumbs up only.

BTW, is that solution working?

[Tahreem24]

@mhendel ,

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

[mhendel]

@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]

@mhendel ,

Validate the below Screen shot:

[mhendel]

@Tahreem24 : yes this is the correct answer 😀

[Tahreem24 · Accepted solution]

@mhendel ,

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])))

[mhendel]

@Tahreem24 !! Yeah it works!!

Thanks for your patience...if i could i'll give you a thousand of kudos :-).

Kind regards,

Michael

[Tahreem24]

Perfecta y buena suerte @mhendel !

[Tahreem24]

@mhendel  Kindly mark my post as a solution.

GOOD LUCK!!!

[Tahreem24]

@mhendel ,

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.

[mhendel]

@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]

@mhendel ,

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]))

[mhendel]

@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]

@mhendel ,

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

[mhendel]

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])

[Tahreem24]

You made little mistake for bracket. 

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]))

Take both the Code de Project and phase par defaut under ALLEXCEPT. Just compare your given measure and mine above measure so you'll get an idea.

I would appreacuate your KUDOS.

[mhendel]

@Tahreem24 Thanks.

I obtain this :  

 It s like it is not filtered by the slice...

Btw what is a kudo?

Regards