**💡 DAX Tip: Dynamic Discount Calculation Based on Bands**
🚀 Ever wondered how to calculate the **total discount** dynamically for each discount band in your dataset? Here's a cool DAX query that summarizes the **Total Discount** for bands like *High*, *Low*, or others, based on specific multipliers!
### Problem Statement:
We want to calculate the **Total Discount** in the `financials` table based on the following conditions:
- **High Band**: Multiply the discount by `1.232`
- **Low Band**: Multiply the discount by `0.23233`
- **Other Bands**: Multiply the discount by `0.5444`
### DAX Query:
```DAX
EVALUATE
SUMMARIZE(
financials,
financials[Discount Band],
"Total Discount",
SUMX(
financials,
IF(
financials[Discount Band] = "High",
financials[Discounts] * 1.232,
IF(
financials[Discount Band] = "Low",
financials[Discounts] * 0.23233,
financials[Discounts] * 0.5444
)
)
)
)
```
### Explanation:
1. **`SUMMARIZE`**: Groups data by the `Discount Band` column.
2. **`SUMX`**: Iterates over the rows in `financials` and applies the multiplier logic for each band.
3. **Logic**:
- If the band is `"High"`, apply `1.232`.
- If the band is `"Low"`, apply `0.23233`.
- Otherwise, use the multiplier `0.5444`.
This query returns the **Total Discount** for each band in an easy-to-understand format. 📊
---
✨ This is a perfect use case of **conditional calculations** in Power BI using DAX. Try it in your reports and let your data tell the story!
💼 #PowerBI #DAX #DataAnalytics #FinancialAnalysis #LinkedInLearning