Forum Discussion
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...
Hi xbommer07 , you can try a measure like this:
Count = COUNTROWS(FILTER('Call Log','Call Log'[Date] = MAX('Call Log'[Date]) && 'Call Log'[Phone Number] = MAX('Call Log'[Phone Number])))
In addition, if you want to show the count value in a visual like table or matrix, you can try an easier measure like:
Count of Call = COUNT('Call Log'[Result])And drag it into the visual’s Values, you will also see the count result calculated automatically and correctly.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.