Forum Discussion
How to skip dimension slicer selection inside facts table GROUPBY operation
For anyone interested. Finally I've been able to resolve the problem. Started from scratch. According to Ultime Dax Guide, groupby is not really efficient so I did back off from it.
[Segment] and [Year] dimensions are forced by visuals fields and visuals/page filters, so I got rid of these from syntax.
Calculate runs sums of [Hours] iterating through all distinct products (if i get the logic correctly). ALLEXCEPT delivers to DISTINCT full list of relevant products ignoring [Country] slicer refinement.
In the end neither SUMMARIZE nor GROUPBY are needed in my scenario.
MAXX(DISTINCT(ALLEXCEPT(Products,Products[ProductSegment])),CALCULATE(SUMX('ProductCosts','ProductCosts'[Hours])))
For anyone interested. Finally I've been able to resolve the problem. Started from scratch. According to Ultime Dax Guide, groupby is not really efficient so I did back off from it.
[Segment] and [Year] dimensions are forced by visuals fields and visuals/page filters, so I got rid of these from syntax.
Calculate runs sums of [Hours] iterating through all distinct products (if i get the logic correctly). ALLEXCEPT delivers to DISTINCT full list of relevant products ignoring [Country] slicer refinement.
In the end neither SUMMARIZE nor GROUPBY are needed in my scenario.
- Icey
Community Support
Hi PawelJanczak ,
Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.
Best Regards,
Icey
