Subcategory Resource Calculation Rollup - Measure Help

[paulsnet1986]

I'm trying to create a measure for a summary report. I have customers with franchises - each franchisee is alotted resources using the formula 1 * (number of franchise locations). Each franchisee's resource usage is subtracted from their allowance and charged overage if they have exceed their capacity at a rate of $15 per resource.

I can build this into a table in Power BI easily, but I need it in a measure for reporting purposes. The desired result would be Customer A = $2,194.84. The summary of the results below. But when I attempt this in a measure, it rolls up all the resources into one big pool and I get a result of $568.56, which is incorrect.

[amitchandak]

@paulsnet1986 , You can have a measure like

calculate(sum(Table[bill], filter(allselected(Table), Table[Parent] = max(Table[parent]) ) )

or

calculate(sum(Table[bill], allexcept(Table,Table[parent]) )