Forum Discussion
Solved
Row Percentages
Im trying to get the % of potential customers by Item and my measure is only giving it by department. How can I get it for each Row? This is what Im looking for in Excel: In Power BI only get...
MStark
It should be rather 81.50, if you want to be precise:Measure = var Potential = CALCULATE(SUMX(FILTER('Table', 'Table'[Department name] = "Potential"), 'Table'[Amount]), ALL('Table'[Department name], 'Table'[Account title])) var TheRest = SUM('Table'[Amount]) var check = DIVIDE(TheRest, Potential) return check
Hello, MStark
You can do something like this:
Measure =
var Potential = CALCULATE(SUMX(FILTER('Table', 'Table'[Department name] = "Potentional"), 'Table'[Amount]), ALL('Table'))
var TheRest = SUM('Table'[Amount])
return DIVIDE(TheRest, Potential)Thanks for taking the time to try to help!
I tried your measure but getting incorrect results. It might be because the Potential Sum is including the potential customers for all 3 months. Maybe the "All" is messing it up? Any ideas?
For May, the total percentage should be 82%
5/31/2022 1on1 0.03 Consulting 0.17 Corp 0.28 Online 0.31 Onsite - Training 0.02 82% Thanks again for your assistance!
MStark
You're using a different formula than I do tho.
Please give me data in text form so I can play with them in my environment, please.Location ID Department name Account title Entry date Amount 101 Customers 1on1 5/31/2022 31.00 101 Customers 1on1 6/30/2022 30.00 101 Customers 1on1 7/31/2022 31.00 101 Customers Consulting 5/31/2022 170.00 101 Customers Consulting 6/30/2022 292.00 101 Customers Consulting 7/31/2022 188.00 101 Customers Corp 5/31/2022 282.00 101 Customers Corp 6/30/2022 317.00 101 Customers Corp 7/31/2022 270.00 101 Customers Online 5/31/2022 312.00 101 Customers Online 6/30/2022 261.00 101 Customers Online 7/31/2022 369.00 101 Customers Onsite 7/31/2022 132.00 101 Customers Training 5/31/2022 20.00 101 Customers Training 6/30/2022 99.00 101 Potential Possible costomers 5/31/2022 1,000.00 101 Potential Possible costomers 6/30/2022 1,000.00 101 Potential Possible costomers 7/31/2022 1,000.00 101 Revenue 1on1 5/31/2022 1,200.00 101 Revenue 1on1 6/30/2022 156.00 101 Revenue 1on1 7/31/2022 165.00 101 Revenue Consulting 5/31/2022 19,999.00 101 Revenue Consulting 6/30/2022 56,555.00 101 Revenue Consulting 7/31/2022 46,468.00 101 Revenue Corp 5/31/2022 5,555.00 101 Revenue Corp 6/30/2022 55,556.00 101 Revenue Corp 7/31/2022 55,555.00 101 Revenue Online 5/31/2022 ######### 101 Revenue Online 6/30/2022 ######### 101 Revenue Online 7/31/2022 ######### 101 Revenue Onsite 7/31/2022 65,000.00 101 Revenue Training 5/31/2022 ######### 101 Revenue Training 6/30/2022 ######### 101 Revenue Training 6/30/2022 ######### Thanks!!
