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.
I am trying to use a filtered row count, but it's not displaying rows resulting in zero rows counted.
Here is my measure formula:
Solved! Go to Solution.
I've given up on trying to get a measure to work and decided to just count it with an M query.
I found this to work:
Hi @dte-chris
are you sure you want to calculate countrows in 'ThreatOccurrencesInTimeframe' table based on 'DevicesOnline' table columns values? do you have appropriate relationships?
@az38 Sorry, maybe I should have written that better. I do have a relationship. What's happening with the +0 is when I do that, the DevicesOnline starts ignoring filtering when I click on a related parent record. With my first query, everything works except rows with zeros are not displayed, and they get filtered when I click on a parent record in the report. With my second query, my DevicesOnline table in the report displays the entire table at all times, not just the ones related to the selected parent.
Do you have a relationship in your data model between ThreatOccurrencesInTimeframe and DevicesOnline ?
Help when you know. Ask when you don't!
@kentyler Sorry, yes there is a one-to-many relationship from DevicesOnline to ThreatOccurrencesInTimeframe.
I've given up on trying to get a measure to work and decided to just count it with an M query.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |