Removing filters

[harshagraj]

Hi all I have total of 89 users(25-Met & 64-Not met) from the column Met_Notmet.
I have a visual where i have applied visual level filter as Met_Notmet = Notmet.

So the value shows is 64. Now i need to show 89 also in the visual.
I tried this Calculate(Count(Users),
all(Met_Notmet))

Instead of showing 89 it is showing 85.

Please help

[v-jingzhang]

Hi @harshagraj 

Check if there is any filter on other columns in the report. Or you could try putting the whole table in All() rather than only the column. 

Calculate(Count('tablename'[Users]),All('tablename'))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[smpa01]

@harshagraj  can you try this 

calculate(COUNT(Users),ALL(Users))