Forum Discussion

RhoFox's avatar
RhoFox
Frequent Visitor
5 years ago
Solved

Count row with same values in two columns

Hi There I need help with some column "count"   Project Date Text Count P1 01.01.2021 text1 1 P1 01.01.2021 text2 2 P1 01.01.2021 text3 3 P1 02.01.2021 text4 1 P...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, RhoFox 

    Please check the below for creating a new column.

     

     

    Count CC =
    VAR currentproject = 'Table'[Project]
    VAR currentdate = 'Table'[Date]
    RETURN
    RANKX (
    FILTER (
    'Table',
    'Table'[Project] = currentproject
    && 'Table'[Date] = currentdate
    ),
    'Table'[Text],
    ,
    ASC
    )

     

     

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

you can do a

 

summarizetable =
SUMMARIZE ( table[Project], table[Date], "RowCount", COUNTROWS ( table ) )