Forum Discussion
ArvindJha
Helper III
Helper IIIpower 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.
ArvindJhaHelper III
Helper IIIEven when i use as measure it does not work :
FlagParameter = IF (
Sheet1[PrevValue] < Threshold[Threshold Value] && Sheet1[CurrValue] >= Threshold[Threshold Value],
"Yes",
"No"
)
Cookistador
Super User
Super UserHi 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