Forum Discussion

paulsnet1986's avatar
paulsnet1986
Helper I
3 years ago

Subcategory Resource Calculation Rollup - Measure Help

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.

 


 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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]) )