Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Parameter is not working as expected

Hello,   I'm trying to use a parameter to select a "positive" and a "negative" group. In the beginning a hardcoded the value 0 as the threshold. Now I would like that threshold to be dynamic by us...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    First, you must know that calculated column and calculate table can't be affected by any slicer. 
    Notice:
    1. Calculation column/table not support dynamic changed based on filter or slicer.
    2. measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
    here is reference:
    https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
    Second, you just need to create a measure instead of column by this formula:

    measure : PostiveNegative = IF(Division[value]>Parameter[Parameter Value],"Positive", "Negative")

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

First, you must know that calculated column and calculate table can't be affected by any slicer. 
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Second, you just need to create a measure instead of column by this formula:

measure : PostiveNegative = IF(Division[value]>Parameter[Parameter Value],"Positive", "Negative")

 

Best Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for your answer! 

     

    I rewrote the logic to a calculated measure and that works!