I am very new to Power BI , and running with an issue. I am sure I will definitely get the solution to my issue here.
The below is a column I have
Col A Occurance
I want to count the occurrences of each value in a column , including the duplicates.
Thanks a ton in advance.
Solved! Go to Solution.
Thanks for the solution . It worked for me. Can you please suggest where & how to increase knowledge in DAX.
I have a column like this
need an out put like
I've jus tried using your suggested solution to count the occurence of each userID in a column and have found the output appears to square each result. For example, where a userID appears twice in the column, the output in the occurrence column is 4 and where userID appears 6 times in the column the output in the occurrence column is 36. Any idea why this is happening? I really can't get my head around it I'm afriad!
Thanks for any help you can provide.
Is there any way to do this on the M Query side of things?
Been looking for a solution, but my M Query is not so strong.