Forum Discussion
Empty colums
I removed every column one by one so see when it went wrong.
It was the "opportunityid" column, data source is Dynamics CRM. Once I removed that column, every calculation worked like it should. It makes no sense, but hopefully this can help someone with the same issue.
Hi FrisoW ,
So this looks like a text column.
Can you replace 0 with NONE in your conditional rule?
Try to keep the values in same data format and then check.
If you still see issues, if it is possible share your pbix file by removing any sensitive information from it.
Thanks,
Pragati
The output ("Estimated value") is a decimal number, or 0 if "TO status" is not "TO".
So the conditional column is also a decimal number.
Even when I replace the 0 with "none", and I select "remove empty", all rows containing numbers are deleted except the ones containing "none". This makes completely no sense to me.
I'll try to remove confidential info of the pbix file later and upload it.
Thanks again
I found the problem but I cannot resolve it.
When I remove all columns that are not needed for that specific conditional column, the step to "remove empty" works like it should and I can filter how I want.
When I add those columns back (totally not related to those I use with the conditional column), the step fails.
I don't know how to proceed.
I removed every column one by one so see when it went wrong.
It was the "opportunityid" column, data source is Dynamics CRM. Once I removed that column, every calculation worked like it should. It makes no sense, but hopefully this can help someone with the same issue.