The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to Solution.
@mhendel ,
So here you go:
@mhendel Kudos means thumbs up only.
BTW, is that solution working?
@mhendel ,
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.
@mhendel ,
Validate the below Screen shot:
@mhendel ,
So here you go:
@Tahreem24 !! Yeah it works!!
Thanks for your patience...if i could i'll give you a thousand of kudos :-).
Kind regards,
Michael
Perfecta y buena suerte @mhendel !
@mhendel Kindly mark my post as a solution.
GOOD LUCK!!!
@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.
@Tahreem24 : thanks for your help.
I tried what you wrote me :
I don' understand why it gives me the default phasis for all the projects and not the one defined by the slicer...
@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]))
@Tahreem24 thanks again for your halp.
I did what you recommend, and i obtain the following erreo :
Where do i amke a mistake?
Regards
@mhendel ,
Show me your measure. I would appreacite your KUODS/THUMBS UP.
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.
@Tahreem24 Thanks.
I obtain this :
It s like it is not filtered by the slice...
Btw what is a kudo?
Regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
93 | |
85 | |
68 | |
65 |
User | Count |
---|---|
241 | |
124 | |
120 | |
81 | |
79 |