Forum Discussion
Solved
Calculation in table
I have a table with me which has a column of category names. I need to get the count of every category and the percentage of the category with total in a visual table/matrix. For example, like this
| Products | nos | Percent |
| A | 3 | 18.75% |
| B | 4 | 25.00% |
| C | 3 | 18.75% |
| D | 3 | 18.75% |
| E | 3 | 18.75% |
| Total | 16 | 100.00% |
Please guide me with a solution
Sorry, I thought "nos" was an actual field.
Try:Count Products = COUNT('Table'[PRODUCTS])% Over totals = DIVIDE ( [Count Products], CALCULATE ( [Count Products], ALL ( 'Table'[PRODUCTS] ) ) )
6 Replies
Try
% over total = DIVIDE ( SUM ( Table[nos] ), CALCULATE ( SUM ( Table[nos] ), ALL ( Table[Products] ) ) )Hi, Why should I need to do sum? I need the count value.
the nos column is the count of every category.lets say that my column is like this
PRODUCTS A A A B B B B C C C D D D E E E from this, I wan to get the count of every category and also the percentage. like this in table / matrix visual
Products nos Percent A 3 18.75% B 4 25.00% C 3 18.75% D 3 18.75% E 3 18.75% Total 16 100.00% Sorry, I thought "nos" was an actual field.
Try:Count Products = COUNT('Table'[PRODUCTS])% Over totals = DIVIDE ( [Count Products], CALCULATE ( [Count Products], ALL ( 'Table'[PRODUCTS] ) ) )
Thanks a lot for the solution.
The ID column will not affect the calculations
