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,
Does anyone know how to count just one instance of a data point that shows up multiple times in the data set? I would also like to filter this data based on a specific threshold.
We have projects that go over a month but the data is separated by the periods so I am looking to get a count of the projects without double counting and I would like to filter these based on projects that are over certain thresholds ($1000,$25000, etc.)
Solved! Go to Solution.
Hi @Drose275
You can use DISTINCTCOUNT( ) and CALCULATE
If you show a sample of your data with an example we can come up with a more accurate answer
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @Drose275
You can use DISTINCTCOUNT( ) and CALCULATE
If you show a sample of your data with an example we can come up with a more accurate answer
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
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.