Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate multiple values based on different values in DAX

Hi guys,   I have one table which register the total contact registrations for each employee on each contact type. We have three different contact type: call, e-mail and inmail.   My current limi...
Need Help
Show and Tell
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous your requirement is totally different from the original post, you are also keeping date in the visual and that is going to be totally different measure. 

 

Explain in detail what you are trying to achieve.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi parry2k ,

 

My requirement is return in a period  a value in total contactregistrations when in a contact registration has been made by value of Call or E-mail or InMail. 

 

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous 

     

    New Measure = CALCULATE ([Total contactregistrations],
KEEPFILTERS(
Dim_ContactType[Type]) IN { "Call",
"E-mail",
"InMail"}
)
)

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡