Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table Bounced Emails as follow:
Email Bounce_Type
a@gmail.com hard
a@gmail.com soft
b@gmail.com hard
c@gmail.com soft
As you can see, this table has no unique ID column! E-mails may repeat.
I want to sum over the first 2 columns like this.
Email Hard count Soft Count
a@gmail.com 1 1
b@gmail.com 1 0
c@gmail.com 0 1
I tried group by options but it did not yield good results.
Could somebody help me?
Thanks!
Freelensia
Solved! Go to Solution.
I ended up doing this:
I ended up doing this:
Hi,
Create a matrix visual. Drag Email to the row labels, Boune_type to the column labels and write this measure
=COUNTROWS(Data)
Hope this helps.
I think you could do that with 2 measures. 1 for each (hard, soft), the idea would then be to setup an IF statement to populate the field if it is hard or soft.
So a calculation you could do would be
ishard = If(Table1[BounceType] = "hard", 1, null) issoft = If(Table1[BounceType] = "soft", 1, null)
last step would just be to count the values
Thanks for the answer!
Sorry but I am completely new to PQ. Could you provide a bit more details on each step?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |