Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 using the parameter.
But the comparison of the real value and the parameter value is not working. It looks like that it still using "0" as the treshold.
Using the following measure and column:
Column: PostiveNegative = IF(Division[value]>Parameter[Parameter Value],"Positive", "Negative")
Someone knows whats going on? Both have decimal number as datatype.
Solved! Go to Solution.
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
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
Thanks for your answer!
I rewrote the logic to a calculated measure and that works!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |