Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm just looking to group Product A into Product B with their quantites sold.
In Tableau, there is the Group feature, but I can't figure out how to do this in BI.
Grouping these two products would give me the sum of both quantities.
If you just need the sum of products A and B, you could put a visual-level filter on your chart and select A and B.
Or you can try to create a new table like:
Group Name | Group |
Group A and B | A |
Group A and B | B |
create a relationship between the two group columns and then use Group Name in your visual.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |