'COUNT number of week with specific value ranges
I have a report that shows me the sales for each department for the current year. This is visualized in a matrix with. The sales table contains a date column that is linked to a simple calendar table that contains information like week, month, year etc. Now I would like to count the number of weeks where
- Strong = Sales above 500k
- Extraordinary = Sales above 750k
- Moderate = Sales below 500k
How is this possible by using a DAX Measures?
Hopefully this works without sample data because I right now have just access to my cell phone.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|