Forum Discussion

Shota_Xuc's avatar
Shota_Xuc
Icon for Helper I rankHelper I
2 years ago

Count rows with same value in one column

Hello,   I have a column "Valuation date" with dates like: 2024-02-06 2024-02-06 2024-02-06 2024-02-07 2024-02-07 2024-02-07 2024-02-09 2024-02-10 2024-02-10 2024-02-12 2024-02-12 2024-...
"Need Help"
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Shota_Xuc , You can try below mentioned measure

 

Count of Valuation Dates =
COUNTROWS(
FILTER(
'YourTableName',
'YourTableName'[Valuation date] = EARLIER('YourTableName'[Valuation date])
)
)

 

Please accept as solution and give kudos if it helps

  • gmsamborn's avatar
    gmsamborn
    Icon for Super User rankSuper User
    2 years ago

    Hi bhanu_gautam 

     

    That DAX won't work for a measure because it "refers to an earlier row context which doesn't exist."

     

    It would work as a calculated column.