How to force a value to 0 when "No data" is displayed
Frohm my spreadsheet source, I create a calculate measure: COUNT_DISTINCT (id)
In some reports I filter this calculated measure on an attribute like status="open".
When my database does not match this filter I get as result a "No data"
I would prefer to get a 0 instead.
I would expect it would behave the same as:
SELECT COUNT_DISCTINT(id) From <datasource> WHERE ID ="open"
Any tip on how to force a value to a calculated measure ?