Weighted Scoring to group/segment customers

[cdawidow]

Hi guys, I need help in terms of a forumla that could provide a weighted score along 2 columns ( margins$ & margin %) based on their associated weights ( 75% for margin$ & 25% for margin%) to then segment into a final class of (A,B,C,D)

I have my Margin$ and Margin % already ranked with associated scores (A-1,B-2,C-3,D-4) but I am having trouble to write a dax formula that can multiply those columns base don their weights to get a final rank

[Greg_Deckler]

@cdawidow Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[cdawidow]

I want to replicate this type of calculation like in excel but in power bi

[Anonymous]

Can you please send the excel sheet that you are trying to replicate in powerbi? Can you upload the sample in google drive or one drive and provide the link? because its not clear that you are trying to do in Excel. Thanks