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] ) ) )
The ID column will not affect the calculations