Forum Discussion
PATHCONTAINS and Multiple selected value
Hi Experts, i have created below measure to calculate aggregated profit amount for locations at parent level (like Continent, Country, Province) which would be summation of children cities. Our D...
Apologies since I'm not familiar with the PATHCONTAINS function, but wouldn't this measure work?
Total by city = CALCULATE([Sum of Profit], ALLEXCEPT(table, table[city]))