Forum Discussion

ns1002's avatar
ns1002
New Member
2 years ago
Solved

How do I filter by rows and count the total?

I need to be able to filter on the columns below to create a new column that filters and counts based on them.   For example, if Type is "AWS" or "Azure" filter based on director and count the numb...
"DAX help"
"DAX"
DAX&Power Query
  • KRISHP1234's avatar
    KRISHP1234
    2 years ago
    Try this 
    Table =     SUMMARIZE(Sheet1,Sheet1[VP],Sheet1[Director],Sheet1[Title],"Counts",COUNTROWS(Sheet1))

     

KRISHP1234's avatar
KRISHP1234
Icon for Helper I rankHelper I
2 years ago
Try this 
Table = SUMMARIZE(Sheet1,Sheet1[VP],Sheet1[Director],Sheet1[Title],"Counts",COUNTROWS(Sheet1))