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 ?
Solved! Go to Solution.
So here you go:
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...
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]))
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.
We have great updates this month! Click the link for the video with more info.