HELP - Fixed Amount Dynamically Change Based On Slicer Selection

[thomazinh]

I have two tables in my simplified example problem, JobIDAmount and JobIDTable. The JobIDTable is a table record of the Job Name and the ID Alpha associated to the corresponding names so that the data in JobIDAmount can be filtered by the Job Name. I am running a fixed denominator calculation so I can find the percent associated by that denominator for each ID Discipline in the JobIDTable. 

I need help dynamically changing the fixed denominator when a new ID Name is chosen in the slicer panel. Right now, I am only able to return the total amount for the fixed demoniator when I need to only return the total amount for only that ID Name selected. 

If I Filter the page by ID Name, Alpha 1671, I expect the Fixed Denominator Measure Amount to be 22 (not 162) and the values in Table 6 to be:

Amount	ID Discipline	1_Division
7	A	0.32
4	B	0.18
12	C	0.54
3	D	0.13
13	E	0.59
3	F	0.14

My Measures are:

1_Division = DIVIDE([1_SumAmount],[1_SumFixed],0)

1_SumAmount = SUM(JobIDAmount[Amount])

1_SumFixed = 
VAR _Filter = FILTER(ALL(JobIDAmount), JobIDAmount[ID Discipline] IN {"A" , "C" , "D"})
VAR _1 = CALCULATE([1_SumAmount],_Filter)
RETURN
_1

Here is the sample file. The link will eventually expire. Please tag me if the problem statement is unclear. Thank you in advance for your help. 

[MFelix · Accepted solution]

Hi @thomazinh ,

You issue is related with the last formula since you are using ALL the filter context is removed and you get the full table returning always the same value redo your measure to using ALLSELECTED you get expected result:

1_SumFixed = 
VAR _Filter = FILTER(ALLSELECTED(JobIDAmount), JobIDAmount[ID Discipline] IN {"A" , "C" , "D"})
VAR _1 = CALCULATE([1_SumAmount],_Filter)
RETURN
_1

[thomazinh]

Thank you! I can't believe this was such a simple solution. I totally forgot about ALLSELECTED.