Calculated column based on slicer

[Anonymous]

Hi everyone,

let's say I have a table Predictions with three columns: prediction (text), confidence (percentage) and is_correct (boolean).

I have a numeric slicer that filters rows with low confidence (greater than filter). I would like to create a calculated column is_above_filter that dynamically updates based on the slicer.

I tried creating a measure min_confidence that gets the minimum of the confidence based on the filter.

Then I created a new table Unfiltered=ALL(Predictions) to avoid filtering of rows.

On the new table I created the is_above_filter column with the condition Unfiltered[confidence]>=min_confidence.

The problem with this approach is that the column doesn't update when the measure updates.

Can you suggest a way of achieving this using Power BI?

Thank you very much

[AlexisOlson]

It is not possible to create a calculated column that is dynamically responsive to a slicer since the calculated column is only computed when loading or refreshing the data model. Measures, on the other hand, are computed dynamically in response to slicers and filters, so this is what you'll need to use.

I can't tell enough from your post to be able to suggest an appropriate measure.

[richbenmintz]

Hi @Anonymous,

Can you use a measure to identify if the row is above the selected slicer value and then filter your table with that? 

If you could share some data, and an expected result with visualization, would be easier to craft a solution