Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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'[Multifa...
"Calculated Column"
new column
  • Anonymous's avatar
    Anonymous
    3 years ago

    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. 

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create a measure. 

total = SUMX(ALL('Release planner'[Index]),[MCS RT])

(3) Then the result is as follows.

 

Best Regards,

Neeko Tang

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes this is what I want to achive, but as in the first space we created a measure for MCS so we can't use the SUM function in line 5 fro MCS RT.