Forum Discussion
Solved
power bi parameter
Hi Team, Below is data ID Subject PrevValue CurrValue 1 123 25 27 1 123 24 24 Below DAX works : Flag = IF ( Sheet1[PrevValue] < 27 && Sheet1[CurrValue] >=...
Hello ArvindJha
Try creating a calculated column instead of measure based on the required condition, it will return "Yes" or "No" for each row. Once this calculated column is created, you can use it in your visuals and slicers to filter and display data according to whether the subject meets the specified criteria.flag_column =
if(
sheet1[prevvalue] < [threshold value] && sheet1[currvalue] >= [threshold value],
"yes",
"no"
)Thanks and Regards.
static values work
it is normal, when you create a calculated column, the column will read the static value and then won't change, it is the same with a slicer parameter
It will change only when you refreshed the semantic model
The measure will be refresh each time something changed on the visual