Forum Discussion

luispenaloza92's avatar
luispenaloza92
New Member
9 years ago
Solved

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 e...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

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