Forum Discussion

ani_informa's avatar
ani_informa
Icon for Helper III rankHelper III
6 years ago
Solved

DAX with Count

Hi   I have a table with data like following snap. I want to write a DAX so that I can count the number of Emails. If Email count is more than 1 then sum those numbers. For example, in below snap, ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi ani_informa 

    As tested under direct query connection, you could create measures instead of calculated columns.

    Measure = CALCULATE(COUNT('test1$'[PersonId]),ALLEXCEPT('test1$','test1$'[Email]))

Measure 2 = COUNTX(FILTER('test1$',[Measure]>1),[Measure])

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Hi ani_informa ,

 

For your requirement you just need to create one measure which count the email id.

Count = COUNT(Sheet1[Email])
 
Then take one slicer for email id and Card to show the above DAX formula.
Find the below screen shot for your reference.
 
Please give Kudos to this Efforts and accept this as a solution if it helps!
 
  • ani_informa's avatar
    ani_informa
    Icon for Helper III rankHelper III
    6 years ago

    Hi Tahreen

     

    I do not want to show value as per email filter.