Forum Discussion

mariogonzra's avatar
mariogonzra
New Member
2 years ago
Solved

Counting rows taking into account different columns

Hi, everyone:   So I'm working with a table that looks basically like this: ReportName PageName UserID Date A A 1 4/7 A B 1 4/7 A C 1 4/7 A A 1 5/7 A B 1 5/7 ...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    mariogonzra,

     

    Try this measure. Since ReportName in the visual provides filter context, it's optional to include ReportName in the SUMMARIZE expression.

     

    Count Measure = 
COUNTROWS ( SUMMARIZE ( 'Table', 'Table'[UserID], 'Table'[Date] ) )

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
2 years ago

mariogonzra,

 

Try this measure. Since ReportName in the visual provides filter context, it's optional to include ReportName in the SUMMARIZE expression.

 

Count Measure = 
COUNTROWS ( SUMMARIZE ( 'Table', 'Table'[UserID], 'Table'[Date] ) )