Forum Discussion

shuberml's avatar
shuberml
Frequent Visitor
6 years ago
Solved

Sum By Row

Hello!    Need help with the correct approach to do the following. I have a table that looks like:  Store State Product Sales A CA Apple 5 A CA Pear 1 A CA Orange 1 A C...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi shuberml 

    Create a table with category and product as below, then relate two tables with "product" column,

    Add columns into matrix and select "sum" aggregation, set filters as below:

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

shuberml , You need to define a category fruit / not fruit, and then it a simple sum.

This can be calculated column

Type = if([Product]<>"Celery","Fruit","Not Fruit")

Then you can filter on Fruit.

 

Or you can try SEGMENTATION

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization