Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |