Percentage of Activations to Signup

[andrewb95]

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? 

[v-danhe-msft · Accepted solution]

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

[kcantor]

@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 %.