Import given Life Science dataset using Get data option in Power BI desktop.
1. Create the following segment in terms of Purchase:
Use DAX function mentioned below to create a new column to classify whether it's Affordable or not,
Price category = if((Purchase[Price]<10), "Affordable", "Expensive")
2. Classified quantities available on the basis of Animal
3. Classification of animals based on land, water and air. The number of animals belonging to each category is shown in the figure 6.3.1
4. Segment on the basis of Species by the referring Animals. Animals and the type of species they are is shown in the figure below.
5. The region to which Town belongs is shown in the figure 6.5.1. Which is obtained by using the DAX function shown below.
Region = RELATED(Region[RegionName])