Forum Discussion

ArvindJha's avatar
ArvindJha
Helper III
1 year ago
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] >=...
Need Help
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    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.

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi ArvindJha ,

Try this below DAX measure, that has worked for me.

Flag Measure =
IF (
    MAX ( 'Table'[PrevValue] ) < [Parameter Value] &&
    MAX ( 'Table'[CurrValue] ) >= [Parameter Value],
    "Yes",
    "No"
)

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

 

Best Regards, 
Chaithra E.