Forum Discussion
Dynamic Slicer to update Thresholds
I believe you can achieve what you want with parameters.
1) Define whichever threshold parameters you want through Modeling > New parameter > Numeric range.
2) Update your measures to reference the threshold parameters instead of the hard-entered values.
Status = IF( [KPI_1] > [KPI_1_Threshold Value] && [KPI_2] > [KPI_2_Threshold Value], "Ok", "Not Ok" )Note that as indicated above, KPI_1 and KPI_2 must be measures, not calculated columns. E.g. if you are trying to compare non-summarized columns, you could just do KPI_1 = SUM( 'Your Table'[Value Column] )
(or perhaps use AVERAGE instead of SUM if you want the tresholds to make sense in (sub)total columns/rows)
Super UserI believe you can achieve what you want with parameters.
1) Define whichever threshold parameters you want through Modeling > New parameter > Numeric range.
2) Update your measures to reference the threshold parameters instead of the hard-entered values.
Status =
IF(
[KPI_1] > [KPI_1_Threshold Value]
&& [KPI_2] > [KPI_2_Threshold Value],
"Ok",
"Not Ok"
)
Note that as indicated above, KPI_1 and KPI_2 must be measures, not calculated columns. E.g. if you are trying to compare non-summarized columns, you could just do KPI_1 = SUM( 'Your Table'[Value Column] )
(or perhaps use AVERAGE instead of SUM if you want the tresholds to make sense in (sub)total columns/rows)