Count of rows after filtering by a measure

[cgambino]

Hello,

I'm wondering how I could get the number of rows remaining after filtering.  I am currently using DirectQuery, and my filter is a measure using a DAX statement.

For example I have a table like so:

Name, Sales, Returns, PercentOfReturnedSales (measure)

George: 10, 1, 10%

Sam: 10, 5, 50%

Susan: 100, 5, 5%

Austin: 100, 85, 85%

Ron: 100, 1,1%

Alex: 100, 35, 35%

I have a filter that says "only show people who's percent of returned sales is over 15%"

So, in this example, it is 3 people. So I want it to show 3.

How would this be possible?

[Anonymous]

Thanks.

This Measure works perfectly. However, since some of my responses are "0", it is giving me "(Blank)". How can I update it to give "0" instead of "Blank".

I thank you.

[twahl]

Dose this function apply a grouping?  what I'm trying to do is group by a value to obtain a count of that value with applied filters. 

.  

Sql example. 

select column1, count(*) [#of records]

from table1

where column2 in ('filter1','filter2')

group by colum1

Thanks, 

tom

[cosborn1231 · Accepted solution]

Hi cgambino,

I hope this helps!

Measure = CALCULATE(DISTINCTCOUNT('Table'[Name]),FILTER('Table','Table'[PercentOfReturnedSales]>15))

[cmcgo3]

you helped me out today with your solution above !!!

[Anonymous]

Hi cosborn1231,

Thanks..it really helps me. But can you suggest how to get 0 (zero) if no data is found in the above query. 

[AdamShaw]

Hi,

Rather new to this myself. But I believe you can get what you want with:

Measure=IF(CALCULATE(DISTINCTCOUNT('Admin Clients'[clientid]),FILTER('Admin Clients','Admin Clients'[id]>15)) = BLANK(),0, CALCULATE(DISTINCTCOUNT('Admin Clients'[clientid]),FILTER('Admin Clients','Admin Clients'[id]>15)))