Calculation does not update when input parameter is modified in slicer

[Anonymous]

pbix file : https://drive.google.com/file/d/1x6u9a1vamiWnaTgJY-yYTIpANlz2FXyn/view?usp=sharing

I want to enable the user to do a simulation in PBI desktop. A color is associated to an ID depending on the risk score of the ID and a threshold the user can play with in the report. The user should be able to see how the amount of IDs per color changes depending on the threshold chosen.

Screenshot of Data tab

screenshot of report tab 

I have tried using a calculated column, but as Ibendlin pointed out, calculated columns cannot be impacted by filter changes, measures or parameters. I tried using the measure suggested by Ibendlin which updates fine, but I cannot figure how to use this "color" measure as a axis in the plot I am trying to make.

[lbendlin]

Your "dependant dimension"  is a calculated column.  Calculated columns cannot be impacted by filter changes, measures or parameters.  You need to change that to a measure. See attached.

[Anonymous]

Thanks Ibendlin, the measure works ! I just updated the post to better reflect my final need

[lbendlin]

That's a very different question.  You need a disconnected table with the possible color values, and then create a different measure that uses COUNTX() to calculate how many items fall into each bucket.

[Anonymous]

Thanks, I will dig into this !