This video is part of DiscoverEI's DAX for Enviro's series, and shows how to calculate species richness and abundance in Power BI using the DAX functions SUM and DISTINCTCOUNT.

If you're interested in learning more about Power BI applications for the environmental industry, then head on over to our website for project examples: https://www.discoverei.com/, take a look at our exciting training courses: https://www.discoverei.com/training, check out our blog posts: https://www.discoverei.com/blog or join in the fun with the community at our #PowerBI4Enviro’s Meetup group: https://www.meetup.com/enAU/powerbi4