Forum Discussion
Frequency Issue Unique values
Hi Community,
I really need your help.
Im trying to creat a colum with the frequency of the distinct Bookings ID per emailAdress, this with the purpose of having the frequency of booking each email had done.
I have issues creating it inside Power BI , i have tried to creat a new table on SQL but i can not link it with my existing table onPowerBi because they must be unique values.
Thanks!
Hi, Using this table like sample data:
Accord to your post you want a calculated column with Distinct Count of Booking Ids in Each Email Address
To obtain this you should use this DAX:
DC-BookingIDperEMail = CALCULATE ( DISTINCTCOUNT ( Table1[BookingID] ), FILTER ( Table1, Table1[Email] = EARLIER ( Table1[Email] ) ) )Now if you just want to show in a visual, you can do it using this:
Regards
Victor
Lima - Peru
2 Replies
Hi, Using this table like sample data:
Accord to your post you want a calculated column with Distinct Count of Booking Ids in Each Email Address
To obtain this you should use this DAX:
DC-BookingIDperEMail = CALCULATE ( DISTINCTCOUNT ( Table1[BookingID] ), FILTER ( Table1, Table1[Email] = EARLIER ( Table1[Email] ) ) )Now if you just want to show in a visual, you can do it using this:
Regards
Victor
Lima - Peru
You may also use DAX below to create a calculated table.
Table = SUMMARIZECOLUMNS ( Table1[EmailAddress], "Count", DISTINCTCOUNT ( Table1[BookingID] ) )
