cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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
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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 381 members 3,488 guests
Please welcome our newest community members: