
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Divide Measure evenly among one dimension
Hello Everyone,
I have a requirement to do following , kindly guide
Dim- Year, Month, Week
Measure -Quantity
I want to calculate Sum of Quantity which is easy but i want to show that Quantity for that particular year and month and week( it should be sum of qty that month /4) so it is evenly distributed for that weeks of month .
Please see below example
Year | Month | week | Qty actual | sum of Qty programmatic( sum of qty for that year month divided by 4 |
2024 | 1 | 1 | 100 | 800/4 = 200 |
2024 | 1 | 2 | 300 | 200 |
2024 | 1 | 3 | 200 | 200 |
2024 | 1 | 4 | 200 | 200 |
2023 | 12 | 49 | 50 | 100 |
2023 | 12 | 50 | 150 | 100 |
2023 | 12 | 51 | 100 | 100 |
2023 | 12 | 52 | 100 | 100 |
2023 | 11 | 48 | 200 | 200 |
2023 | 11 | 47 | 300 | 200 |
2023 | 11 | 46 | 200 | 200 |
2023 | 11 | 45 | 100 | 200 |
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you @qv_testing and @Anil_Babu_Samineni both of your solution worked, i wonder why i didnt think about adding month 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
SUM(TOTAL <Month>[Qty actual])/4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@AT_7 one correction,
SUM(TOTAL <Month>[Qty actual])/Count(week)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you @qv_testing and @Anil_Babu_Samineni both of your solution worked, i wonder why i didnt think about adding month 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you guys know if i have to move it to script how to do

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry it didnt work when i pull all years .
what it did is for january it pull out numbers for 2024, 2023 jan and than divide it by 4 😞
