Forum Discussion
Calculating a mean/average based on a measure
Hello guys, I have the following measure which counts the number of occurrences of product IDs within a column. Occurrence = COUNT('Table'[Product ID]) Since I would like to find out how oft...
Hi Anonymous
I believe what you are looking for is if
| Product ID |
| A |
| B |
| A |
Then you need the output as
| product ID | Occurrence |
| A | .66 or 66% |
| B | .33 or 33% |
Occurrence = count('Table'[Product ID])/CALCULATE(COUNTROWS('Table'),ALLSELECTED('Table'))
IF you need it in percentage convert the measure to %