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...
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.

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

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's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    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.