cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nicksonteh
Advocate II
Advocate II

how to calculate ratio

Hi everyone, hope you doing well. 

May I know how can I calculate filter based on the example below. 

I want to calculate the percentage of invoice amount that have a contract number. 

For exmaple, picture below shown that 100, 200, 300 have a contract number beside . so the ratio should be  100 + 200 + 300 = 600 divide by the total invoice amount 100 + 200 + 300 +100 = 700. 

600/700 = 85%

 

nicksonteh_0-1654071016319.png

 

thank you. 

regards

 

1 ACCEPTED SOLUTION
DimaMD
Super User
Super User

Hi,@nicksonteh Is this your result?Screenshot_14.jpg
  

View solution in original post

2 REPLIES 2
DimaMD
Super User
Super User

Hi,@nicksonteh Is this your result?Screenshot_14.jpg
  

hi @DimaMD ,

yes ! thank you so much !

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10

The Power BI Community Show

Join us on October 3 at 11 am PST when Amit Chandak, a Power BI Super User, will demo how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors