Forum Discussion

Jamie_Hughes's avatar
Jamie_Hughes
Frequent Visitor
7 years ago
Solved

Cumulative Count

Hi,   I am new to Power BI and DAX and I was wondering if someone could help me.   I have a table with duplicated names in a column, I would like a DAX formula to count the amount of times it see...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi Jamie_Hughes

     

    To do this in DAX..you will need to add an Index Column from the Query Editor first.

     

    Then you can use this Calculated Column

     

    Instance_ =
RANKX ( FILTER ( Table1, [Name] = EARLIER ( [Name] ) ), [Index],, ASC, DENSE )

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Hi Jamie_Hughes

 

To do this in DAX..you will need to add an Index Column from the Query Editor first.

 

Then you can use this Calculated Column

 

Instance_ =
RANKX ( FILTER ( Table1, [Name] = EARLIER ( [Name] ) ), [Index],, ASC, DENSE )