DAX Intentional BLANK Total Is Overridden by Visual Filter

[WinterMist]

Hello Community -

In the following table visual, the totals for the following measures are intentionally blank.

- Accounts 

- Retained

- Retained %

These 3 measures (renamed) show BLANK for the Total row by using ISFILTERED on the Year.

So far so good.

The problem comes when I need to only show rows in the table visual where CY Premium > 0.

For example, 2024 is currently showing in the table visual, but should not appear until CY Premium > 0.

To achieve this, the following visual filter is created.

GOOD - This filter correctly hides the 2024 row because CY Premium is not greater than 0 in that year. 

BAD - However, doing so breaks the intentional BLANKING of the 3 measures mentioned at the beginning of this post.

How do I get both requirements to work at the same time?

I thought about doing the ISFILTERED on a different column in the table.

The problem is that every column in the table visual (except Year) is just another measure which cannot be used in the ISFILTERED clause to BLANK a measure in the totals row.

Any guidance would be greatly appreciated.

Regards,

Nathan

[WinterMist]

@tamerj1 - Thank you, yet again!  Helpful as always.

[tamerj1 · Accepted solution]

Hi @WinterMist 

you can use HASONEVALUE