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
    )

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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.