Kaggle Power BI File used as reference : https://www.kaggle.com/datasets/yoonc12/insurance-data-set-power-bi

Slidescope’s Dashboard as seen in the image file : https://github.com/slidescope/data/blob/master/insurance%20data.pbix

“Insurance Charges Dataset”, often used in data science and machine learning tutorials.

It contains information about patients such as:

• age: Age of the primary beneficiary
• sex: Gender of the beneficiary (male/female)
• bmi: Body Mass Index
• children: Number of children/dependents covered by insurance
• smoker: Smoking status (True/False)
• region: Residential area in the US (northeast, southeast, southwest, northwest)
• charges: Medical insurance charges billed by health insurance

It’s frequently used to model and predict insurance costs using regression algorithms like Linear Regression, Decision Trees, and more.

DAX Column

Applicants = COUNTROWS(insrance)

BMI Category = 
SWITCH(
    TRUE(),
    insurance[bmi] < 18.5, "Underweight",
    insurance[bmi] >= 18.5 && insurance[bmi] < 25, "Healthy weight",
    insurance[bmi] >= 25 && insurance[bmi] < 30, "Overweight",
    insurance[bmi] >= 30 && insurance[bmi] < 40, "Obese",
    insurance[bmi] >= 40, "Severely obese",
    "Unknown"
)