% of total by category

[Anonymous]

I'm trying to display a % of total for each category, however I can't get it to work. 

_% of Total measure is showing 100% for all... I tried to extract the part where the formula would need to return 493 for every row, regardless of category, however all my data is still filtered. How do I get the formula to work?

Here's what I have so far:

_% of Total = DISTINCTCOUNT('Billing Stats'[WO#]) / CALCULATE(DISTINCTCOUNT('Billing Stats'[WO#]),ALL('Billing Stats'[WO#]))

[chethan]

@Anonymous

use the below DAX for %

Total % = 
		DIVIDE(
			CALCULATE(
				SUM('Producer'[Value])
				) , 
			CALCULATE(
					SUM(Producer[Value]),
					ALL('Producer')
					)
				)

attached Sample here

[Anonymous]

It's still showing 1 for each entry. BI seems to be ignoring the ALL() function.

_% of Total = DIVIDE(
	DISTINCTCOUNT('Billing Stats'[WO#]), 
	CALCULATE(
		DISTINCTCOUNT('Billing Stats'[WO#]),
		ALL('Billing Stats'[WO#])
	)
)

[chethan]

@Anonymous

Please share sample file, so it very useful to understand.

regards,

Chetan K

[Anonymous]

Here it a sample: https://1drv.ms/u/s!AkBC9S_qYIPlge9a9c1bH5cQ_D3ppQ

[chethan · Accepted solution]

@Anonymous

try this here

[Anonymous]

How did you get the values to display as %? Calclulation is invalid, percentages should add up to 100%. Here's what Excel comes up with:

Row Labels	N	Y	Grand Total	N	Y
Aug
burnsl	1152	124	1276	20.74%	25.15%
ferraiol	613	265	878	11.04%	53.75%
garcong	1448	33	1481	26.07%	6.69%
kingd3	4	5	9	0.07%	1.01%
maielloe	2337	66	2403	42.07%	13.39%
stoleare	1		1	0.02%	0.00%
Aug Total	5555	493	6048

[Ashish_Mathur]

Hi,

I get the correct result.  Download the workbook from here.