Posts: 325
Registered: ‎12-04-2017

Column not Calculating Correctly



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?

Regular Visitor
Posts: 25
Registered: ‎10-23-2018

Re: Column not Calculating Correctly

Just curious, do you have data that shows negative numbers? If not maybe you can remove the second IF() and see what happens.

Senior Member
Posts: 390
Registered: ‎04-14-2018

Re: Column not Calculating Correctly



can you create a measure with a formula like this:


measure = if ( sum(employee_count) >0 && sum(employee_count) <=50, "0-50" etc



Community Support Team
Posts: 7,232
Registered: ‎08-14-2016

Re: Column not Calculating Correctly

 Hi @mrainey,


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.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |