Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Having trouble with %Shared Formula with Measure

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())

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

3 Replies