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 ...
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] ) ) )
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] ) ) )This helps a lot. But I got another doubt. What if I have ID column which has duplicate values like this
id PRODUCTS 1 A 1 A 2 A 2 B 3 B 3 B 4 B 5 C 6 C 7 C 8 D 8 D 9 D 10 E 11 E 12 E if this is the table, I should be doing distinct count ?
please guide me with a logic