% PER ROW FROM GRAND TOTAL

[MNM]

Hi Everyone,

Good day! 

I am trying to get the % per row from grand total  for the difference of target and cleared. However, it seems to get the % from the total per region instead the % from grand total. Need your expertise on this please.

my formula :

Cleared Past Due % =

('TS Raw'[Cleared] / 'TS Raw'[PREV DAY TARGET])

PREV DAY TARGET =

CALCULATE('TS Raw'[Target @90%], PREVIOUSDAY('Calendar Table'[Date]))

Cleared =

VAR PrevDate =

    PREVIOUSDAY('Calendar Table'[Date])

VAR PrevSum =

    CALCULATE(

        'TS Raw'[Forward Aging Total Collectibles],

        'Calendar Table'[Date] = PrevDate

        )

RETURN

    IF(

        PrevSum <> 0 && 'TS Raw'[Forward Aging Total Collectibles] <> 0,

        PrevSum - 'TS Raw'[Forward Aging Total Collectibles]

    )

Thank you in advance.

[amitchandak · Accepted solution]

@MNM , If I have measure [Cleared]  and I need % of total

then I need a  measure like

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

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s