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.
No matter the employee size per company, my calculated column just says everybody has a size of 0-50 even though that's clearly not true. Why is it doing this?
Hi @Anonymous,
Did this measure which used in calculated column calculate dynamic result based on slicer?
If this is a case, current power bi not support to create a dynamic calculate column/table based on slicer, dynamic dax formula will been fixed as static value when you use it in calculated column/table.
Regards,
Xiaoxin Sheng
@Anonymous
can you create a measure with a formula like this:
measure = if ( sum(employee_count) >0 && sum(employee_count) <=50, "0-50" etc
Just curious, do you have data that shows negative numbers? If not maybe you can remove the second IF() and see what happens.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |