cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrewb95 Visitor
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). Power BI Community.PNG

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-danhe-msft Super Contributor
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:

1.PNG

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
kcantor Super Contributor
Super Contributor

Re: Percentage of Activations to Signup

@andrewb95 

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!




v-danhe-msft Super Contributor
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:

1.PNG

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
Virtual Launch Event

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

Power BI Helps Homeless and Trouble Youth

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

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