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 ...
Need Help
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]) )