Objective – Power BI Desktop, Cloud Service and End to End Workflow
Use Case – DAX Measures
Source – LifeScience
Analytics – DAX Groupings
Report/Dashboard – LifeScience
As per the requirement, we need to create a new segment(affordable or expensive) in terms of purchase. Here I created the new segment using add conditional column, see the figure below.
New segment column is created in purchase table, see the figure below.
Created a report on the quantities available on the basis of Animal. Here I used a text table to create the report using values as Animals, Quantity and Segment, see the fig below.
Count of animals by environment, here I used donut chart to distinguish the count of animals with it's environment name.
As per the 4th requirement, created a segment on the basis of Species by the referring Animals in the product table using DAX function.
SpeciesType = RELATED(Species[FamilyName])
Final requirement is to segment the towns on the basis of region. Created a new column using DAX function