Hello,
I have a dataset with product information. This issue is about products, customer group and profit columns. I have included different slicers in my dashboard which filter out the unprofitable products. For example, one slicer shows all products with a negative profit.
Now I want to show in a visualization the profit of the filtered products by a category (e.g. customer group) in relation to the profit of the total unfiltered profit of the products by a category (e.g. customer group). For visualization, I had thought of a stacked bar chart, for example. I would also find a slope chart exciting, where it can be seen how much the profit of a customer group is in percentage unfiltered and filtered (by the slicers).
A first approach was the function:
Total =
CALCULATE(
SUM('Table'[Profit)]),
ALL('Table')
)
This shows me the unfiltered totals, but not grouped by different categories. Maybe I can group by the different customer groups via the groupby function!? This I have so far unfortunately not yet managed.
I hope you can help me! Many thanks in advance!
