Subcategory Resource Calculation Rollup - Measure Help

Question

I'm trying to create a measure for a summary report. I have customers with franchises - each franchisee is alotted resources using the formula&nbsp;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.&nbsp;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.&nbsp;&nbsp;

amitchandak · Answer

paulsnet1986 , You can have a measure like 
&nbsp;
calculate(sum(Table[bill], filter(allselected(Table), Table[Parent] = max(Table[parent]) ) )
&nbsp;
or
&nbsp;
calculate(sum(Table[bill], allexcept(Table,Table[parent]) )

Forum Discussion

Related content

Category/Subcategory Calculation

Less resource consumption

Azure resource graph and KQL

Ranking in subcategories

Deleted eventstream still using resources