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?
Go to Solution.
I hope this helps!
Measure = CALCULATE(DISTINCTCOUNT('Table'[Name]),FILTER('Table','Table'[PercentOfReturnedSales]>15))
View solution in original post
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.
select column1, count(*) [#of records]
where column2 in ('filter1','filter2')
group by colum1
Thanks..it really helps me. But can you suggest how to get 0 (zero) if no data is found in the above query.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.