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
    )

     

     

RhoFox's avatar
RhoFox
Frequent Visitor
5 years ago

ooooh it works 😄
thank you a lot
I just saw that I still have a problem, I have another column with true / false values, it should only count if the column = true

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, RhoFox 

Thanks for your feedback.

Please share your sample pbix file's link here, then I can try to look into it.