Forum Discussion

xbommer07's avatar
xbommer07
Frequent Visitor
5 years ago

Count rows where two different columns are equal

Hello BI Team,    I have read a number of posts on this topic however I cannot find one that is just right.    I have a table, the data source is SQL. The table name is Call Log.    Columns are...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

xbommer07 You could create a column or measure like this:

Column = 
    VAR __Table = FILTER('Table (20)',[Date]=EARLIER([Date]) && [Phone Number]=EARLIER([Phone Number]))
    VAR __MaxResult = MAXX(__Table,[Result])
RETURN
    IF(__MaxResult=3,COUNTROWS(__Table),BLANK())


Measure =
    VAR __Phone = MAX([Phone Number]
    VAR __Date = MAX([Date])
    VAR __Table = FILTER('Table (20)',[Date]=__Date && [Phone Number]=__Phone ))
    VAR __MaxResult = MAXX(__Table,[Result])
RETURN
    IF(__MaxResult=3,COUNTROWS(__Table),BLANK())