DAX - %contribution for status measure filed to particular years

[Anonymous]

hi everyone,

i have sample super store table. and i calculated "Actual Sales". now i wanted to show "Actual sales" %contribution for each status on particular year.

can any one help on this. data provided in this link.

.

Thanks in advance

regards

venu

[Anonymous]

anybody help on this... my sample output in this link.

[HotChilli]

Looks like you need

a) a measure to SUM [Actual Sal] taking into account Year and Status.

b) a measure to SUM [Actual Sal] taking into account Year

Then DIVIDE a by b

That should give you a start

[Anonymous]

@HotChilli  Thanks for your response.... that is not working....

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

Please try the measure below.

Measure 2 = 
VAR totalforeachyear =
    CALCULATE (
        SUM ( 'Table1'[Actual sales] ),
        ALLEXCEPT ( Table1, 'Table1'[Year] )
    )
VAR salesforeachstatus =
    CALCULATE (
        SUM ( 'Table1'[Actual sales] ),
        ALLEXCEPT ( Table1, Table1[Status_], Table1[Year] )
    )
RETURN
    salesforeachstatus / totalforeachyear

Here is the output.

More details, please refer to my attachment.

Best  Regards,

Cherry