I am attempting to create a view in Power BI which shows the % of Activations which occur to signups.
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?
Go to Solution.
Hi @andrewb95 ,
Based on my test, you could refer to using divide function:
And with below measure:
Measure = DIVIDE(CALCULATE(SUM(Table1[Activation])),CALCULATE(SUM(Table1[Sgnups])))
You could also download the pbix file to have a view.
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 %.
Proud to be a Datanaut!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.