Forum Discussion

Freefly's avatar
Freefly
Frequent Visitor
8 years ago
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. ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Freefly

     

    You can also us this MEASURE

    Measure =
CALCULATE (
    COUNTROWS ( TableName ),
    ALLEXCEPT ( TableName, TableName[Data1], TableName[Data2] )
)

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Freefly,

 

Could you please mark the proper answer as solution?

 

Best Regards!
Dale