Forum Discussion

abeirne's avatar
abeirne
Icon for Helper II rankHelper II
4 years ago
Solved

Using filter functions on a measure in table

Hi all, I am trying to show the email capture rate of my stores, but the table I am currently using shows all of the employees. I would like to show the email capture rate per store versus per employ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi abeirne ,

     

    Are 'Invoice_Detail_' [GC] the same for the same stores?

    Please try this formula.

    Email Capture % =
CALCULATE (
    DISTINCTCOUNT ( Invoice_[Customer_Email_Address] ),
    FILTER ( ALL ( Invoice_ ), [stores] = SELECTEDVALUE ( stores ) )
)
    / SELECTEDVALUE ( 'Invoice_Detail_'[GC] )

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi abeirne ,

 

Are 'Invoice_Detail_' [GC] the same for the same stores?

Please try this formula.

Email Capture % =
CALCULATE (
    DISTINCTCOUNT ( Invoice_[Customer_Email_Address] ),
    FILTER ( ALL ( Invoice_ ), [stores] = SELECTEDVALUE ( stores ) )
)
    / SELECTEDVALUE ( 'Invoice_Detail_'[GC] )

 

Best Regards,

Jay