Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi cgambino,
I hope this helps!
Measure = CALCULATE(DISTINCTCOUNT('Table'[Name]),FILTER('Table','Table'[PercentOfReturnedSales]>15))
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.
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
Hi cgambino,
I hope this helps!
Measure = CALCULATE(DISTINCTCOUNT('Table'[Name]),FILTER('Table','Table'[PercentOfReturnedSales]>15))
you helped me out today with your solution above !!!
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.
Hi,
Rather new to this myself. But I believe you can get what you want with:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |