Countif as same as Countif($A2:A450,A450) in Power BI

[titusissam]

Can someone help in acheiving below count in Power BI.

Name	Count
A	1
B	1
C	1
D	1
A	2
A	3
A	4
B	2
B	3
C	2
D	2

[parry2k · Accepted solution]

@titusissam try following measure

Count = 
CALCULATE( COUNTROWS( Table1 ),
FILTER( ALLEXCEPT( Table1, Table1[Name] ),
Table1[Index] <= MAX( Table1[Index] ) ) )

[parry2k]

@titusissam you need to have date or index column in your model to calculate running total.

[parry2k]

@titusissam you need to have some sort of index or date to calculate running total. What other columns you have in model?

[titusissam]

Thanks for your reply @parry2k 

yes i do have an index column which has row number in it.

[parry2k · Accepted solution]

@titusissam try following measure

Count = 
CALCULATE( COUNTROWS( Table1 ),
FILTER( ALLEXCEPT( Table1, Table1[Name] ),
Table1[Index] <= MAX( Table1[Index] ) ) )

[titusissam]

yea i got this answer based on an earlier post, but i want the occurance number.

Eg., If "A" repeats 10 times count column should have 1,2,3, etc.,

Thanks again for your help on this.. 🙂

Current output:

[parry2k · Accepted solution]

@titusissam did you tested the measure I sent to you. i tested at my end it works

[titusissam]

yea working fine in measure.. thank u.... 🙂 🙂