Forum Discussion

RenataOGardner's avatar
RenataOGardner
Icon for Helper II rankHelper II
5 years ago
Solved

Dax measure help.

Hi guys,

 

I have the table below with people who have registered to the company's webshop. Some people used social media to register and with that, I don't know their emails. What I need to do is to get the percentage of the number o customers who register using social media vs people who did the registration. The difference between them is, #numbers and names without an email, and a normal email with the '@'.

 

Many thanks,

Renata

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, RenataOGardner 

    I tried to create a sample pbix file based on the explanation.

    Please check the below picture and the sample pbix file's link down below.

     

     

    Email Registration =
    DIVIDE (
    CALCULATE (
    COUNTROWS ( 'Table' ),
    CONTAINSSTRING ( 'Table'[Registration], "@" )
    ),
    COUNTROWS ( 'Table' )
    )
     
     
    Without Email Registration =
    DIVIDE (
    CALCULATE (
    COUNTROWS ( 'Table' ),
    not CONTAINSSTRING ( 'Table'[Registration], "@" )
    ),
    COUNTROWS ( 'Table' )
    )
     
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, RenataOGardner 

    I tried to create a sample pbix file based on the explanation.

    Please check the below picture and the sample pbix file's link down below.

     

     

    Email Registration =
    DIVIDE (
    CALCULATE (
    COUNTROWS ( 'Table' ),
    CONTAINSSTRING ( 'Table'[Registration], "@" )
    ),
    COUNTROWS ( 'Table' )
    )
     
     
    Without Email Registration =
    DIVIDE (
    CALCULATE (
    COUNTROWS ( 'Table' ),
    not CONTAINSSTRING ( 'Table'[Registration], "@" )
    ),
    COUNTROWS ( 'Table' )
    )
     
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM