Power BI count

[Drose275]

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.)

[AlB · Accepted 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