Show no data available on the card when multiple card selection

[ssk_1984]

Hi All,

I have page with year, month, region, country, vertical, horizontal filter and showing values on the visual by distinct count of project.

Here i have used card visuals to show 

NoDataGov = IF(ISBLANK(COUNT(GOVERNANCE[PROJECT_ID])),"No NCs","")

, if i random selection of other slicers again showing blank visuals. Please help to fix that

How to include all filter to validate there is blank  vaues are appearing or not

[v-linhuizh-msft · Accepted solution]

Thanks for the concern from AnkitKukreja.

Hi  @ssk_1984 , 

Based on your description, I've created the following sample tables:

 

You can modify the original code to determine if the number of Project_ID is null when all the slicers have been applied.

The modified measure is as follows:

MEASURE =
IF (
    ISFILTERED ( 'Date'[Month] ) && ISFILTERED ( 'Country'[Country] )
        && ISFILTERED ( Region[Region] )
        && ISBLANK ( COUNT ( Projects[Project_ID] ) ),
    "No NCs",
    ""
)

Here are the results:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[AnkitKukreja]

Hi! @ssk_1984 

Can you attach your sample pbix file and share the expected solution, there might be a relationship issue among those fields.