Row Percentages

[MStark]

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 getting the total:

Can anyone help with this?

If it helps, my excel data looks like this:

[vojtechsima]

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)

[MStark]

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!

[vojtechsima]

@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.

[MStark]

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!!

[vojtechsima · Accepted solution]

@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

[MStark]

This works!! Thank you very Much!!

[vojtechsima]

No problem @MStark