Forum Discussion
aflintdepm
Helper III
Helper IIICount Occurrence in a Column- must be dynamic
I have a column of data with recurring entries. There are about 10 unique choices, but these can occur an infinite of times. I would like to count how many times each reason appears, but...
Hi aflintdepm
I was able to simulate the output without using any DAX.
In matrix visual, do these steps:
Rows -> Date
Columns -> Reason
Values -> Count of Reason (not distinct)
-> Count of Reason (Show value as percentage of total)
Rename the value headers accordingly.
Output:
Let me know if I am missing something.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aflintdepmHelper III
Helper IIII'm not sure you're missing anything, but I definitely am
Not sure what I'm doing wrong
bharath_v
Resolver I
Resolver ICan you check on the filters section to see if you are filtering data?
- aflintdepm
No slicers on the page, no filters on the visual, as far as I can tell
Does it have anything to do with the fact that the Reason column is text?