Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help with google analytics data

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 tryin...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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 )

    9.21.1.1.PNG

    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