Conversion rate Dax Calculation

DAX DAX Calculations
1

Good day team,

hope all is well. I need some guidance on calculating a conversion rate of customers from product 1 to product 2:

The calculation need to first sum all customers who are converted (shows value of 1) divide them by count of customers in the same table.

in excel i calculated as below:

=(SUM(H:H)/COUNT(H:H))
image
image
Mastering DAX.pbix (473.3 KB)

image

1 Like
2

Good day all,

Hoping someone can help with this measure?

Regards
Neilon

1 Like
3

Hi,

Can you tell me one thing when i open the pbix i find 44% i assuming it is not right can you tell me what will be the right value and how its obtain like :

14/2 =7

So i can help you quickly.

And is this right this answerer attached below :
image

Thanks

1 Like
4

Hi,

As per you above description you need to first count how many customer has been converted we need to count only those customer who has one in product 2 converted

As you see in the below attached visual its 16 :

image
image772×436 52.9 KB

You can see i checked it by Appling extra filter on visual itself

After that i divided that with total number of customer(50)
Total no. of customer in the below attached screenshot:
image

By dividing it i got the above mention result in my earlier comment .

Attaching the pbix just evaluate it let me is it what you want:
Mastering DAX (1).pbix (473.2 KB)

1 Like
5

this great, question i have is:

instead of using the filter of product name in filter pane, can this be incorporated into the dax statement?

image

1 Like
6

Hi @neilonbooysen ,

After reading your above comment i am assuming my provided solution worked for you .

For your second on this thread we can apply those filter on our calculation it self because at the end the visual filter act as filter for our calculation .

You can write like below:
EDNA Total Sales Product 1 =
CALCULATE (
[Total Sales],
Products[Product Name] = “Product 1”
)

It work same and did not require you to put filter on visual.

I hope its solve your query.

Thanks

1 Like
7

all good thanks so much for your help

1 Like
8

Hi,
Then mark my reply which conation the pbix as solution to close this thread .
So in future some one faces same kind of issue they know which comment to look

I am glad that i am able to help you.

Thanks

1 Like