Forum Discussion
Getting the same total value for each category
Hi Experts, I am facing issue with one of the measure, Target_V = CALCULATE(SUM('goal'[targetmoney_base]),ALLEXCEPT(opportunityproduct,opportunityproduct[productfamilylevelaname])) gett...
Hi Anonymous
yes. it will give you the value by applying ALLEXCEPT().
can you pls show case by taking normal table and add all the product columns and targetmoney_base and check share screenshot what value do you need against which product value.???
You can do the same thing in excel just random data with all level of hierarchy and show wht data you want to show again each category.
share input and expected output..