Work out a percentage of the row subtotal to the total

[abloor]

Hi there,

Can you please help me do the DAX for the '% of total' measue for the below?   It seems like it should be so simple but I can't work it out.  Please note it has to be based on a revenue measure, not a column.

Thank you

	Revenue written in the last week measure	% of total
Station
Cliffton Hills	$         50,000	50%
Alexandria	$         30,000	30%
Davenport Downs	$         20,000	20%
	$         100,000	100%

[amitchandak · Accepted solution]

@abloor , Try measures like

Divide([revenue], calculate([revenue], allselected()))

Divide([revenue], calculate([revenue], allselected(Table)))

[abloor]

Perfect, thanks very much @amitchandak  your first measure worked for what I need.

Thanks again!