Dax measure help.

[RenataOGardner]

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

[Jihwan_Kim · Accepted solution]

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' )

)

https://www.dropbox.com/s/4lzjn5hkn6qz53w/renata.pbix?dl=0 

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

[RenataOGardner]

Thank you so much Jihwan Kim!