Forum Discussion

naveen73's avatar
naveen73
Icon for Helper III rankHelper III
2 years ago

Generate column with count of values

Hi all,   I am working with a dataset and merging another set and applying filters. At some point I am getting the “Value” column (see screenshot). However, the values are a sum of each of the “Pr...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

=DIVIDE(SUM(Table[Volume]),CALCULATE(SUM(Table[Volume]),ALLEXCEPT(Table,Table[Product Code])))