Forum Discussion

harshagraj's avatar
harshagraj
Icon for Post Partisan rankPost Partisan
4 years ago

Removing filters

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

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.