Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter by column AND (boolean) measure

I want this calculation to work, so that I can create a slicer that shows sum of purchases a customer made day 5, 14 and 30 after they received an email. There are 2 filters that need to work 1. ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I managed to solve it:

    Total Conversion =
    switch (TRUE,
    Min ( Msr1[MsrId]) = 1,
    CALCULATE(DISTINCTCOUNT('Onboard'[custid]), 'Onboard'[num_trx_5days] > 0),
    Min ( Msr1[MsrId] ) = 2,
    CALCULATE(DISTINCTCOUNT('Onboard'[custid]), 'Onboard'[num_trx_14days] > 0),
    Min ( Msr1[MsrId] ) =
    CALCULATE(DISTINCTCOUNT('Onboard'[custid]), 'Onboard'[num_trx_30days] > 0))
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.