Forum Discussion
SUM unique values from filtered table
Hello, everyone! I am new in Power BI, and I haven't been able to start my dataviz because I'm stuck with the data transformation. I have a data set that is essentially this. I hav...
smpa01
Community Champion
Community ChampionThis is the sample table I have 😄
Country Store ID Store Class Employees Products Total employees per country Total employees per country per store class Luxembourg 12 A 5 Rice 98 50 Luxembourg 12 A 5 Beans 98 50 Luxembourg 543 B 25 Cucumber 98 25 Luxembourg 543 B 25 Rice 98 25 Luxembourg 543 B 25 Beans 98 25 Luxembourg 4757 A 45 Rice 98 50 Luxembourg 4757 A 45 Tomatoes 98 50 Luxembourg 23 C 3 Tomatoes 98 3 Luxembourg 23 C 3 Beans 98 3 Luxembourg 23 C 3 Chicken 98 3 Luxembourg 224 D 20 Beans 98 20 Luxembourg 224 D 20 Pasta 98 20 Germany 357 A 32 Cucumber Germany 357 A 32 Rice Germany 357 A 32 Beans Germany 2356 A 6 Rice Germany 2356 A 6 Tomatoes Germany 2356 A 6 Chicken Germany 2356 A 6 Beans Germany 9 D 8 Rice Germany 9 D 8 Tomatoes Germany 9 D 8 Chicken Germany 9 D 8 Beans Germany 9 D 8 Cucumber Germany 9 D 8 Pasta Germany 97 B 54 Lemon Germany 97 B 54 Beans Germany 97 B 54 Cucumber France 23 C 5 Cucumber France 23 C 5 Beans France 23 C 5 Lemon France 23 C 5 Pasta France 568 A 23 Carrots France 568 A 23 Chicken France 568 A 23 Pasta France 568 A 23 Lemon France 568 A 23 Coriander France 568 A 23 Beans France 67 A 9 Chicken France 67 A 9 Pasta France 67 A 9 Carrots France 3267 D 49 Chicken France 3267 D 49 Pasta France 3267 D 49 Lemon France 3267 D 49 Coriander France 3267 D 49 Beans France 111 A 27 Chicken France 111 A 27 Pasta France 111 A 27 Lemon