Frequency Issue Unique values

[luispenaloza92]

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!

[v-chuncz-msft]

@luispenaloza92,

You may also use DAX below to create a calculated table.

Table =
SUMMARIZECOLUMNS (
    Table1[EmailAddress],
    "Count", DISTINCTCOUNT ( Table1[BookingID] )
)

[Vvelarde · Accepted solution]

@luispenaloza92

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