How to display a different text/value instead of (Blank)

[Anonymous]

Hi all,

I am having this scenario. Two views, one header view, and another details (transaction) view. I have a KPI card visual, which display total sales (from the transaction view). This will be filtered by the list of customers from header view. Whenever I choose a customer which does not have any transaction, the KPI card display (Blank) instead of '0' which I intended. I have tried the following (IF(IsBlank(transaction_value)), 0, transaction_value) yet to no avail.

Any idea what I am missing?

Thanks.

[Anonymous · Accepted solution]

@Anonymous  - create a new Measure like this:

Transaction Value Measure = SUM(yourtable[transaction_value]) + 0

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.