Forum Discussion
ALL/ALLSelected in summarize table not working
I have a scenario, we send multiple emails to users and in return we get leads generated due to the emails we send. Now, there are chances that a leads submitted by a user might have received more t...
amitchandak
Super User
Super UserSenthil_Kumar , Try measure like
divide(istinctcount(Table[Lead_id]), distinctCOUNT(Table[Email_sent_id]))
or
Sumx(Values(Table[Lead_id]), calculate( divide(istinctcount(Table[Lead_id]), distinctCOUNT(Table[Email_sent_id])) ))