Forum Discussion
power bi parameter
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.
Hello ArvindJha
It is normal, a calculated column will be refreshed only when you refreshed your dataset
You have to use a measure to achieve that
This dax measure returns what you try to achieve
Flag Measure = IF (
SELECTEDVALUE('Table'[PrevValue]) < 27 && SELECTEDVALUE('Table'[CurrValue]) >= Parameter[Parameter Value],
"Yes",
"No"
)
For the Parameter, I created a new parameter ==> Numeric range
Even when i use as measure it does not work :
FlagParameter = IF (Sheet1[PrevValue] < Threshold[Threshold Value] && Sheet1[CurrValue] >= Threshold[Threshold Value],"Yes","No")Hi ArvindJha
It is normal, use the following dax measure instead
Flag Measure = IF (
SELECTEDVALUE('Sheet1'[PrevValue]) < 27 && SELECTEDVALUE('Sheet1'[CurrValue]) >= Threshold[Threshold Value],
"Yes",
"No"
)You have to aggregate your column to use a measure
