aggregated

2 Topics

Month segmentation so that when selecting it, all previous months can be observed (aggregate).
Hello, I have a page with two segmentations: Year (2021,2022,2023) and Month (1,2,3,4,5,6,7,8,9,10,11,12). I have several visualizations that depends on DAX measures which work correctly if I select any month or group of months (e.g 2023-01 or 2023-01,02,03,04,05,06,07,08). I wanted to improve the user experience with a segmentation or a button called "YTD", that when I select it, what it does is directly filter the entire page with all the months prior to the selected month. For example if I am visualizing the page with data from 23-08, when selecting this option "YTD", automatically the visualization of the page will be 23-01,02,03,04,05,06,07,08, to see the aggregate. If you had 22-04 checked, what you would see is 22-01,02,03,04. Is like a quick option to avoid selecting each prior month separetly. Bookmarks is not an option, it is really messy with so many possible selections. Thanks, any advice is greatful!
Solved
Francisco_MS_PB
2 years ago Place DAX Commands and Tips
819Views
0likes
2Comments
Measure not working as expected in hierarchy
Hello, I have the following example data: Model Submodel Sold units demand forecast ABS(sold units-demand) x x1 3 2 1 x x2 4 7 3 x x3 15 4 11 x x4 6 4 2 I would like now to sum the different abs values (0+1+1+2) in model granularity, but instead, when applying to a Matrix, it calculates the abs as the following: (3+4+15+6) - (2+7+4+4) = 28-17 =11 While I would like it to sum it like: (1+3+11+2) = 17 So the table would be: Model Sold units Demand Forecast sum of Abs x 28 17 17 I have been trying everything and searching around. What is the proper way of doing this, and understanding it? Thanks in advance
Anonymous
3 years ago Place DAX Commands and Tips
1.1KViews
0likes
4Comments