Get Percentage for a specific colunm

[Gabe_07]

Hello everyone, 

I'm trying to get the percentages of the percentage of specific columns but Power Bi is getting the percentage across the row instead of a single colunm.

-------------------------------------------------------------------------------------------

AF % (DAX) = 

AF % =

VAR __BASELINE_VALUE = [Total Weight]

VAR __VALUE_TO_COMPARE = SUM('BatchHeaders'[AF Column])

RETURN

    IF(

        NOT ISBLANK(__VALUE_TO_COMPARE),

        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE) * -1

    )

----------------------------------------------------------------------------------

AZ % (DAX) =

VAR __BASELINE_VALUE = [Total Weight]

VAR __VALUE_TO_COMPARE = SUM('BatchHeaders'[AZ Column])

RETURN

    IF(

        NOT ISBLANK(__VALUE_TO_COMPARE),

        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE) * -1

    )

I'd appreciated if anyone could help me. Thank you

[amitchandak · Accepted solution]

@Gabe_07 , Try something like this

divide(SUM('BatchHeaders'[AF Column]) , calculate( [Total Weight], allselected('BatchHeaders')))

divide(SUM('BatchHeaders'[AZ Column]) , calculate( [Total Weight], allselected('BatchHeaders')))

[Gabe_07]

Thank you so much @amitchandak, your DAX really helped me!