Need help with google analytics data

[Anonymous]

Hi everyone, 

I am creating a dahsboard with Google Analytics data. 
I have several metrics, 2 of them are Users and Screened-out (people who have been screened out from the site). 

I am trying to create graphs where I can see data of users who haven't been screened out.

I tried to use a filter "screened out=0" but it gave me wrong data. 

Any tricks?
Thanks!

[VijayP]

@Anonymous 

Calculate(Total Count, filter(all(Tablename),status = "Screened Out")

[v-eqin-msft · Accepted solution]

Hello @raphaelle95 ,

Not very clearly...... You seem to set a flag (1 and 0) for the screen user, don't you?

filterrd =
IF ( MAX ( 'FilterTable'[Screened-out ] ) = "Yes", 1, 0 )

Have I answered your question? Please mark my answer as a solution. Thanks a lot.

If not, load some insensitive data samples and expected output.

Best regards

Eyelyn Qin