Forum Discussion

Ramzay's avatar
Ramzay
New Member
9 years ago
Solved

Implementing in DAX SQL query with COUNT and GROUP BY

In need to implement in DAX a table definition similar to the result of the following simple SQL query: SELECT Col1, Col2, Col3, COUNT(*) FROM Tab1 GROUP BY Col1, Col2, Col3 Than...
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    Add new measure with following formula

     

    TotalCount = COUNTROWS('your table name')

    Now add Table visual and drop you col1, col2, col3 and TotalCount measure on it, it should do it.

parry2k's avatar
parry2k
Super User
9 years ago

Add new measure with following formula

 

TotalCount = COUNTROWS('your table name')

Now add Table visual and drop you col1, col2, col3 and TotalCount measure on it, it should do it.

Ramzay's avatar
Ramzay
New Member
9 years ago

Thanks.  That is what I need.