Forum Discussion
Power BI count
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.)
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
1 Reply
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