% PER ROW FROM GRAND TOTAL

Question

Hi Everyone,Good day!&nbsp;I am trying to get the % per row from grand total&nbsp; for the difference of target and cleared. However, it seems to get the % from the total per region instead the % from grand total.&nbsp;Need your expertise on this please.&nbsp;my formula :Cleared Past Due % = ('TS Raw'[Cleared] / 'TS Raw'[PREV DAY TARGET])&nbsp;PREV DAY TARGET = CALCULATE('TS Raw'[Target 90%], PREVIOUSDAY('Calendar Table'[Date]))&nbsp;Cleared = VAR PrevDate = &nbsp; &nbsp; PREVIOUSDAY('Calendar Table'[Date])VAR PrevSum =&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; 'TS Raw'[Forward Aging Total Collectibles],&nbsp; &nbsp; &nbsp; &nbsp; 'Calendar Table'[Date] = PrevDate&nbsp; &nbsp; &nbsp; &nbsp; )RETURN&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; PrevSum &lt;&gt; 0 &amp;&amp; 'TS Raw'[Forward Aging Total Collectibles] &lt;&gt; 0,&nbsp; &nbsp; &nbsp; &nbsp; PrevSum - 'TS Raw'[Forward Aging Total Collectibles]&nbsp; &nbsp; )&nbsp;&nbsp;Thank you in advance.

amitchandak · Accepted Answer

MNM , If I have measure [Cleared]&nbsp; and I need % of total 
&nbsp;
then I need a&nbsp; measure like
&nbsp;
Divide([Cleared] , calculate([Cleared] , allselected())
&nbsp;
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2hohttps://www.youtube.com/watch?v=cN8AO3_vmlY&amp;t=24270s

Forum Discussion

% PER ROW FROM GRAND TOTAL

1 Reply

Related content

Formatting grand total in matrix

Display Grand total

Grand Total Only

Dax measure accumulation no Sub / grand total

Grand Totals colum