Forum Discussion
Helper IIICount Occurrence in a Column- must be dynamic
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.
Resolver IHi 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.
Helper IIII'm not sure you're missing anything, but I definitely am
Not sure what I'm doing wrong
- bharath_v
Can 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?