SUMIFS function in Power BI

Cbishop ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if this cane help

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Appreciate your Kudos.

Cbishop 

If I'm reading the formula correctly, you want to calculate the percentage of each planned cost over the total planned cost by group and month, right?

if so:

Planned cost over grouped planned cost =
VAR PlannedCost = SUM(table[Cost 2020/21 - Plan])

VAR GroupedPlannedCost = CALCULATE(PlannedCost, ALLEXCEPT(table, Table[group], table[month]))

RETURN

DIVIDE(PlannedCost, GroupedPlannedCost) * 100

PS, if you wish to display the value as a percentage, you don't need to mutliply by 100; just format the measure to display a percentage

Hi Cbishop 

Just like AllisonKennedy and  PaulDBrown replied before we can achieve the goal by measure.

I build a table like yours in power bi to have test.

I build a measure to calculate Cost2020/21-Plan / sum{Cost2020/21-Plan (group = group month = month) }*100:

Measure =
VAR _A =
    SUM ( 'Table'[Cost 2020/21 - Plan] )
VAR _B =
    SUMX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Group] = MAX ( 'Table'[Group] )
                && 'Table'[Month] = MAX ( 'Table'[Month] )
        ),
        'Table'[Cost 2020/21 - Plan]
    )
RETURN
    DIVIDE ( _A, _B ) * 100

Result:

If you want to calculate other like sum value filtered by (EXP Group 2 = EXP Group 2 and National Specialty = National Specialty and Month = Month).

You may refer to the formula _B in my measure, like :

_C =
SUMX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[EXP Group2] = MAX ( 'Table'[EXP Group2] )
            && 'Table'[Month] = MAX ( 'Table'[Month] )
            && 'Table'[National Specialty] = MAX ( 'Table'[National Specialty] )
    ),
    Value
)

You can download the pbix file from this link: SUMIFS function in Power BI

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

Best Regards,

Rico Zhou

Hi Cbishop 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

Hi All,

Unfortunately all the suggestions didn't complete the required final result and as such I am unable to accept one as a solution.

I have managed to find a workaround to adhere to tight deadlines and will be revisiting this in due course.

Best Regards

Craig