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.
ArvindJha Click on "New Parameter" and create a parameter named Threshold Value.
Set the data type to the appropriate type (e.g., Whole Number) and define the minimum, maximum, and default values.
Once the parameter is created, it will be available in your data model.
You can then reference this parameter in your DAX formula.
FlagParameter = IF (
Sheet1[PrevValue] < 'Parameter Table'[Threshold Value] && Sheet1[CurrValue] >= 'Parameter Table'[Threshold Value],
"Yes",
"No"
)
Even when i use as measure it does not work :
FlagParameter = IF (Sheet1[PrevValue] < Threshold[Threshold Value] && Sheet1[CurrValue] >= Threshold[Threshold Value],"Yes","No")
