Percentage per Category and Month

[Anonymous]

Hi.

I'm trying to make a percentage over category and month but I don't know how to do.

I have categories in rows and months in column and I need to make the percentage over the total. 

I have tried to use ALLSELECTED but it didn't work as expected.

[PabloDeheza · Accepted solution]

Hi there!
Try the following:
% =

VAR _CurrentValue =

    [R$]

VAR _AllValue =

    CALCULATE(

        [R$],

        ALL( Category ),

        ALL( MonthName )

    )

VAR _Result =

    DIVIDE(

        _CurrentValue,

        _AllValue

    )

RETURN

    _Result

Let me know if that helps!