visual calculation error when filtering on date cannot conver to date/time

Hi Anonymous 

This error message appears when the visual calculation tries to return a text value (like "N/A" or "") in a context where a numeric or date value is expected.
It usually happens when a filter (like a date filter) changes the context and causes part of the formula to evaluate differently — for example, a DIVIDE() that returns blank, or a conditional expression (IF, SWITCH) with inconsistent return types.

To check what's causing it:

1. Recreate the visual calculation as a regular DAX measure with the same logic.

2. Use SELECTEDVALUE, DIVIDE, and IF carefully — make sure all branches return a consistent data type (preferably numeric).

3. If any branch returns text (even ""), replace it with BLANK() or a default numeric like 0.

If the DAX version works with no issues under the same filters, it's likely a bug or limitation in the visual calculation engine.

In that case, report it as a bug the issues , please include the link to the pbix

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly