Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Example: I have a table with opportunityProduct and have the A_productfamily, B_productfamily,C_productfamily& D_productfamily as categories and i want to map all the above categories files to my Target value. to get the right values for each product family i tried with All EXCEPT function, which is not working in my DAX logix.

 

Please suggest. 

 

Note: Target value is a measure from a goal table which is not have an direct relationship with OpportunityProduct table.

 

Please help

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Does the goal table have a field corresponding to “A_productfamily”, “B_productfamily”, “C_productfamily ” & ‘D_productfamily’?

 

If so, try something like this.

Target_V =
CALCULATE (
    SUM ( 'goal'[targetmoney_base] ),
    'goal'[productfamilyfield]
        = SELECTEDVALUE ( 'opportunityproduct'[productfamilylevelaname] )
)

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group