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...
xbommer07 , A measure for 3 and 1 happened on the same day by the same number
countx( filter(summarize(Table, Table[Date],Table[Phone Number],
"_1" , countx(filter(Table,Table[Result] =3),Table[Phone Number]),
"_2" , countx(filter(Table,Table[Result] =1),Table[Phone Number])
),not(isblank([_1])) && not(isblank([_1]))),[Phone Number])