equivalent measure to sql count(*) group by

[sa34techer]

What is the equivalent way to write a dax calculation from this SQL statement below with COUNT(*)?

SELECT codes, COUNT(*) as violations
FROM TABLE
GROUP BY codes
ORDER BY codes DESC

[hackcrr · Accepted solution]

Hi, @sa34techer 

In DAX  used in Power BI, you would typically create a measure to replicate the functionality of a SQL COUNT(*) grouped by a certain column. Here's how you can create a DAX measure to replicate the SQL statement you provided:

Violations =  
CALCULATE(  
    COUNTROWS(TABLE),  
    ALLEXCEPT(TABLE, TABLE[codes])  
)

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.