Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Kelly_Zhu
Helper III
Helper III

How to calculate Total Percent

‎01-14-2018 10:14 PM

Hi Everyone,

 

I would like to create a table like below. Could you provide me some suggetion about this? Thank you in advance!

 

Percent.PNG   

Regards,

Kelly

Labels:
Message 1 of 3
812 Views
0
1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

‎01-15-2018 02:46 AM

@Kelly_Zhu

 

This MEASURE should get you desired result

 

Percent =
SUM ( Table1[Column B] ) / SUM ( Table1[Column C] )

 


Regards
Zubair

Please try my custom visuals

View solution in original post

Message 2 of 3
862 Views
2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

‎01-15-2018 02:46 AM

@Kelly_Zhu

 

This MEASURE should get you desired result

 

Percent =
SUM ( Table1[Column B] ) / SUM ( Table1[Column C] )

 


Regards
Zubair

Please try my custom visuals
Message 2 of 3
863 Views
Kelly_Zhu
Helper III
Helper III
In response to Zubair_Muhammad

‎01-15-2018 09:34 PM

Thanks for your help!!!

Message 3 of 3
788 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All