Forum Discussion
Calculated Column filter dynamic
Hi
I have created a new column with dax this way :
MCS =
VAR CurrentKey = 'Release planner'[FC ID]
VAR MultifactorFiltered = FILTER('Multifactor PI Calculator', 'Multifactor PI Calculator'[Multifactor PI] = "2023PI3")
VAR MatchingKey = COUNTROWS(FILTER(MultifactorFiltered, 'Multifactor PI Calculator'[FC number] = CurrentKey))
VAR DividerToUse =
IF(
MatchingKey > 0,
MAXX(MultifactorFiltered, [Value]),
'Release planner'[FC size]
)
RETURN
IF(
DividerToUse < 1,
'Release planner'[MCS Effort] * DividerToUse,
'Release planner'[MCS Effort] / DividerToUse
)
There reason behind this is that sometimes the column need to be calculated from a different table. I am using this column on different tabs as well and it needs to be able to change by everytab. In the line 3 "2023PI3" part needs to be dynamic in someways, slicer filter not sure.
I have tried to create a new table with just these values and use it as a slicer but it would change the end value.
Thanks inadvance
Hi Anonymous ,
If you wish to replace "2023PI3" with the value selected by the slicer, you need to
1. Create a measure instead of a calculated column, because calculated columns cannot change dynamically.
2. Create a slicer table.3.Change "2023PI3" in the metric to SELECTEDVALUE('Slicer Table'[Value]), which will change depending on the value of the slicer.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous ,
If you wish to replace "2023PI3" with the value selected by the slicer, you need to
1. Create a measure instead of a calculated column, because calculated columns cannot change dynamically.
2. Create a slicer table.3.Change "2023PI3" in the metric to SELECTEDVALUE('Slicer Table'[Value]), which will change depending on the value of the slicer.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the help, it worked , do you mind helping me with this part as well? I want to create a running total of this measure, for which I have an index column for the order. This was the older version:
MCS RT = VAR currentIndex = MAX('Release planner'[Index]) RETURN CALCULATE( SUM('Release planner'[MCS]), FILTER( ALLSELECTED('Release planner'), 'Release planner'[Index] <= currentIndex ) )
Many thanks already