Showing results for 
Search instead for 
Did you mean: 
mrainey Member

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?


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.

themistoklis New Contributor
New Contributor

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
Community Support Team

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: | |