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 |