How to Count the number of Records in a Result set

[Anonymous]

Hello,

I have a measure setup in Power BI, that produces the follow results (see image below).  What I need to do is count the number of result recors. In the example below it is 12 records. This seems simple but I can't get any of the COUNT functions to produce what I need.

[Anonymous]

Thank you foodd ! Your solution worked. I am good now.

[foodd]

Using a DAX Measure like:  Row Count of Incidents = COUNT('Service Desk Metrics'[Average Actual Value])

[Anonymous]

Thanks foodd.  The Average Actual Value column is a Measure itself, and it won't let me select it in the COUNT function you specified above.

[foodd · Accepted solution]

If it is the count of rows for the table you could use:: 

count rows of incident table = COUNTROWS('Service Desk Metrics')

If it is the count of rows for calculated column AAV you could use::

count rows of calculated AAV column = COUNTX('Service Desk Metrics','Service Desk Metrics'[Average Actual Value])

Check out  the Microsoft Learn DAX Reference on Aggregated functions

Of that, the examples used in your case were COUNTROWS or COUNTX

Refer to DAX Guide for curated assistance from sqlbi.com.

Their tool DAX.do by SQLBI is helpful as well.

If for some reason you are yet to start using DAX Studio, Tabular Editor, and Measure Killer, I highly 

encourage you to install them now.