Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MarcUrdang
Post Patron
Post Patron

How to create a percentage

Hi ... please could you help me understand how to create a %.

 

There is a field called TEU and another called TEU Forecast. I have inserted them into one graph as per attached file and need to see each rows %:

 

https://drive.google.com/open?id=1e743QaBFNcJGIeVr1ORWcxK6h45Fkj3L

 

ie. if the TEU sum is 11 and the TEU forecast is 20 then you should see 55%

 

Can you show me how to do this .. the SHOW value as row % doesn't seem to work.

Thanks

Marc

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @MarcUrdang - Since these are columns, not measures, you'll need to do something like this:

TEU Forecast % = 
DIVIDE(
    SUM('Consol INBOUND'[TEU]), 
    SUM('Consol INBOUND'[TEU Forecast])
)
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

 

View solution in original post

3 REPLIES 3
savvari
Helper I
Helper I

@MarcUrdang 

 

You can create a measure

Percent TEU Actual = DIVIDE(SUM(TEU), SUM(TEU Forecast))

and format it as Percentage from the Modeling ribbon on top.

 

I would have attached the modified file, but I don't see the option here. And I cannot upload a file from my work laptop. I'll upload from my personal machine in a few minutes.

Hi .. thank you so much HOWEVER .. if you try this in the .pbix you will see that the function DIVIDE .... doesn't pick up either of the two fields:  

 

1. TEU

2. TEU Forecast

 

Any ideas?

thanks

Marc

Anonymous
Not applicable

Hi @MarcUrdang - Since these are columns, not measures, you'll need to do something like this:

TEU Forecast % = 
DIVIDE(
    SUM('Consol INBOUND'[TEU]), 
    SUM('Consol INBOUND'[TEU Forecast])
)
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.