cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FreedJustine
Helper I
Helper I

Create a Measure to Calculate ratio base on Amount in same colum

Please help, i want to get % to REV base on Sub Catergory="Sales"
 
Below are the following measures i use.
 
Amount =sum(Report[AMT])
 
SalesAmt =
CALCULATE([Amount]),Report[Sub Catergory]="Sales")
 
% to Rev = DIVIDE([Amount],[SalesAmt])
 
Result should be
Sales 100%
Sales Discount 3%
Commission 10%
 
Thank you very much everyone ❤️
Capture.JPG
2 REPLIES 2
rfigtree
Resolver III
Resolver III

The denominator will be blank on your 2 dud rows.

Try this

SalesAmt =
CALCULATE([Amount]),filter(all(report[Sub category]),Report[Sub Catergory]="Sales"))
 

Thanks @rfigtree but still the denominator is blank 😢

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors