Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure/ Column

Hi everyone,   I need your help in the following:    I want to do another column /measure to have Opportunity X sum as 39486.96 and Opportunity Y sum as 60735.6, how can I achieve that? There are...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

First of all, I want to know if the data you gave is the original data.

If it did not the original data, I made an attempt with the following data.

 

Expected Value = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Opportunity  ]))
Average =CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[Opportunity  ]))

 

If it's still not the result you want, please share the raw data with me and let me know about your thoughts.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Community Support Team _ Polly