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] )
)

     

Sachy123's avatar
Sachy123
Icon for Helper V rankHelper V
8 years ago

I used Group by in the Edit Queries and grouped the data with data 1 and data 2.

Is this what you want?

 


= Table.Group(#"Changed Type", {"data 2", "data 1"}, {{"Count", each Table.RowCount(_), type number}})

 

Freefly's avatar
Freefly
Frequent Visitor
8 years ago

Thanks for a quick anser.
Is that the exact syntax? tried to put it in under In in the advace editor but got error

Like this

https://msdn.microsoft.com/en-us/library/mt260774.aspx#Arguments

 

PrefeblyI dont what to alter the columns since I used them for other things as well and these are just two of many columns in the DB

 

 

  • Sachy123's avatar
    Sachy123
    Icon for Helper V rankHelper V
    8 years ago

    Perhaps you can use Group BY in the Transform tab