cancel
Showing results for
Search instead for
Did you mean:
Visitor

Percentage of Activations to Signup

I am attempting to create a view in Power BI which shows the % of Activations which occur to signups.

• My data is sorted by year/month and I would like to see the % change.
• I have the fields for:
• Total Signups
• Total Activations
• Date of Signup

I have below added a small image from Excel displaying how ideally my data would be shown (the red segment showing % change).

Can someone please advise how I can show this (create this measure) for use within a matrix table?

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

Re: Percentage of Activations to Signup

Hi @andrewb95 ,

Based on my test, you could refer to using divide function:

https://docs.microsoft.com/en-us/dax/divide-function-dax

And with below measure:

`Measure = DIVIDE(CALCULATE(SUM(Table1[Activation])),CALCULATE(SUM(Table1[Sgnups])))`

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super Contributor

Re: Percentage of Activations to Signup

You would create a measure using the Divide function.

First, make sure you have measures for the Activations and Signups using SUM

Activations = SUM(TableName[Activation])

Signups = SUM(TableName[Signups])

Then, Create your % measure referencing those other measures instead of columns.

% Activations to Signups = DIVIDE([Activations], [Signups])

Then format as a %.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super Contributor

Re: Percentage of Activations to Signup

Hi @andrewb95 ,

Based on my test, you could refer to using divide function:

https://docs.microsoft.com/en-us/dax/divide-function-dax

And with below measure:

`Measure = DIVIDE(CALCULATE(SUM(Table1[Activation])),CALCULATE(SUM(Table1[Sgnups])))`

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 161 members 2,090 guests
Recent signins:
Please welcome our newest community members: