Forum Discussion
Solved
Counting number combinations in two columns
Hi, trying to count how many time a specif pair fo data occurs in two colums. I dont know what combination that my occur and the point is to find out what pair or combination that is most frequent. ...
You can also us this MEASURE
Measure = CALCULATE ( COUNTROWS ( TableName ), ALLEXCEPT ( TableName, TableName[Data1], TableName[Data2] ) )
Freefly I found a way to count that in Power BI Desktop
1. Be sure your columns are tagged as text.
2. You have to concatenate columns Data1 and Data2 (see image):
Use the function "add a Custom Column" and Concatenate your fields :
Now it should look like that :
Then, use the function "Group By" (see image, in red):
Group by "Concatenate",
Operation : "Count"
You now have your "Counting" operation that is automated ! See image
You can also us this MEASURE
Measure =
CALCULATE (
COUNTROWS ( TableName ),
ALLEXCEPT ( TableName, TableName[Data1], TableName[Data2] )
)