Count occurrences in DAX

Question

I need to count the no of occurrences of each value in the column with duplicates from the table mentioned below

Column A 1 2 3 1 2 3 4

I need 

Column A	Occurrence
1	2
2	2
3	2
1	2
2	2
3	2
4	1

Answer 1

You can use DAX functions to do so, which will be:

Occurence = 
COUNTX (
    FILTER ( yourTable, EARLIER ( yourTable[Col A] ) = yourTable[Col A] ),
    yourTable[Col A]
)

COUNTX -This function Counts the number of rows of that table that contain a number or an expression that evaluates to a number when evaluating an expression over