DAX Intentional BLANK Total Is Overridden by Visual Filter

WinterMist — Thu, 30 Mar 2023 19:02:17 GMT

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

Re: DAX Intentional BLANK Total Is Overridden by Visual Filter

tamerj1 — Thu, 30 Mar 2023 19:17:18 GMT

Hi WinterMist

you can use HASONEVALUE

Re: DAX Intentional BLANK Total Is Overridden by Visual Filter

WinterMist — Thu, 30 Mar 2023 19:26:02 GMT

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

topic Re: DAX Intentional BLANK Total Is Overridden by Visual Filter in DAX Commands and Tips

DAX Intentional BLANK Total Is Overridden by Visual Filter

Re: DAX Intentional BLANK Total Is Overridden by Visual Filter

Re: DAX Intentional BLANK Total Is Overridden by Visual Filter