Having trouble with %Shared Formula with Measure

[Chanleakna123]

hi all , i wanna calculate the %Contribution in each year based on Business Type. in each year total %100

but what i have is Y_2021 which is calculated from Measure below  , and i use the Percentage of Grand Total  in BI , but shown 0% , it is wrong , which formula that i can use to acheive this ?  

but when i use visualize "100% Stack Column Chart " in BI , it generates the result i wanted . But it is Column Chart , I want it to be on Line Chart. 

Y_2021 = SWITCH(TRUE(),

'Final Measure'[Final Selection]="UC",[UC],

'Final Measure'[Final Selection]="$NSR",[$NSR],

'Final Measure'[Final Selection]="Total Transaction",[Total Transaction],

'Final Measure'[Final Selection]="$NSR/UC",[$NSR/UC],

'Final Measure'[Final Selection]="Total Industry NSR",[Total Industry NSR],

'Final Measure'[Final Selection]="UC Total Industry",[UC Total Industry],

BLANK())

[amitchandak]

@Chanleakna123 , try like the approach given in

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

[Chanleakna123]

hi , actually  i have acheived this , but the thing is when i continue doing another formula for %contribution , it doesn't work out 

[v-xicai · Accepted solution]

Hi @Chanleakna123 ,

You may create measure like DAX below.

%Contribution =
DIVIDE (
    CALCULATE (
        [Y_2021],
        FILTER (
            ALLSELECTED ( Table1 ),
            Table1[Year] = MAX ( Table1[Year] )
                && Table1[ Business Type] = MAX ( Table1[ Business Type] )
        )
    ),
    CALCULATE (
        [Y_2021],
        FILTER ( ALLSELECTED ( Table1 ), Table1[Year] = MAX ( Table1[Year] ) )
    )
)

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.