cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LucienF38 Regular Visitor
Regular Visitor

measure = percentage of transformed quotations

Dear all,

 

I wish to create a new column in my visualization with the percentage of "Transformé" column as a function of column "Total". The issue is that the 3 columns are due to 3 different values of a unique column. It is quite hard with my frenchy english to explain it so please find below captures that will make it clearer. 

Capture1.PNG

 

Capture.PNG

For example, for the first row I'd like to show that the percentage of "transformé" in comparison with "total" is : 7,73% or even better : 8%

 

Thanks for helping Smiley Happy 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
tejaswidmello Established Member
Established Member

Re: measure = percentage of transformed quotations

HI @LucienF38 ,

 

1.Drag yout transform Field to the values panel here

Capture6.PNG

 

2. Once in the Value, right click on that field --> Show value as ->percent of row total.

Capture7.PNG

 

Hope this helps.

 

Thanks,

Tejaswi

1 REPLY 1
Highlighted
tejaswidmello Established Member
Established Member

Re: measure = percentage of transformed quotations

HI @LucienF38 ,

 

1.Drag yout transform Field to the values panel here

Capture6.PNG

 

2. Once in the Value, right click on that field --> Show value as ->percent of row total.

Capture7.PNG

 

Hope this helps.

 

Thanks,

Tejaswi

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: 390 members 4,283 guests
Please welcome our newest community members: