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

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

Forum Discussion

Using filter functions on a measure in table

Related content

Caclulate function over riding filter?

filter function

Dynamic measure filtering

Filter by Rank measure

Use measure in FILTER function