Forum Discussion

NullMN's avatar
NullMN
Frequent Visitor
3 years ago
Solved

Formula help please - Count each unique email & then total count of those appearing once.

Hi - I'm fairly new to PowerBI and was hoping someone might be able to help.  I've been hunting in the Community and I'm struggling to find a way to accomplish this.   My team produces events and o...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi NullMN ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create 2 measures.

    Measure =
CALCULATE (
    COUNT ( 'Table'[Email] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Email] = SELECTEDVALUE ( 'Table'[Email] ) )
)

    Measure2 =
CALCULATE (
    MAX ( 'Table'[Purchase Date] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Email] = SELECTEDVALUE ( 'Table'[Email] ) )
)

     

    If I have misunderstood your meaning, please provide more details with desired output and pbix file without  privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Satya_Bhamidipa's avatar
Satya_Bhamidipa
Icon for Helper I rankHelper I
3 years ago

Please check my solution 

 

Count of Mail ID =
COUNTX (
    FILTER ( 'Sheet1 (2)', EARLIER ('Sheet1 (2)'[Mail ID] ) = 'Sheet1 (2)'[Mail ID] ),
    'Sheet1 (2)'[Mail ID]
)