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

Column not Calculating Correctly

1.PNG

 

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?

3 REPLIES 3

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

@mrainey

 

can you create a measure with a formula like this:

 

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

 

 

Highlighted
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.

 

Regards,

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