Forum Discussion

Carliniiiii's avatar
Carliniiiii
Frequent Visitor
2 years ago
Solved

Count by category

Hello Power BI community,    I have following data set:  Project Location Project1 A Project1 A Project1 B Project2 B Project2 C   I would like to count each different...
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Carliniiiii , You can use Summarize function for this and create a new table by going into modelling section

     

    NewTable =
    SUMMARIZE(
    'YourTableName',
    'YourTableName'[Location],
    "Frequency", COUNTROWS(SUMMARIZE('YourTableName', 'YourTableName'[Project], 'YourTableName'[Location]))
    )

  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Carliniiiii , Create another table using

     

    GroupedData =
    SUMMARIZE(
    YourTableName,
    YourTableName[Location],
    YourTableName[Response],
    "Frequency", COUNT(YourTableName[Response])
    )

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Carliniiiii , You can use Summarize function for this and create a new table by going into modelling section

 

NewTable =
SUMMARIZE(
'YourTableName',
'YourTableName'[Location],
"Frequency", COUNTROWS(SUMMARIZE('YourTableName', 'YourTableName'[Project], 'YourTableName'[Location]))
)