Calculating the % Value of 2 counted and filtered measures

[zoomclub]

Hi,

I have a table where I have:

A column called : company_name (where I store all the registered companies)

A column called : status (where you can have ACTIVE, INACTIVE, OTHER)

And another table where I have:

A column called : product_name (where I store all the orders of products)

A column called : status (where you can have ACTIVE, INACTIVE, OTHER)

What I want to do is:

1) Count all the companies which have the status: ACTIVE

2) Count all the products which have the status: ACTIVE

3) Calculate the Conversion, which means for me dividing the product count / company count and return a % value 

What I did is (which is probably not right) - I created 2 filtered measures in order to be able to create another measure making the divide but still i get only a number not a %.

Please help me

[Nathaniel_C · Accepted solution]

Hi @zoomclub ,
Have your measure in the formula bar,go to the modeling tab, change the format to percentage. I would also suggest you use DIVIDE().
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[amitchandak]

Can you share the formula you created and issue you are getting