Hide future year(s) from slicer visual
I placed the following "Year" ("Ano") slicer on a report page by adding the year column from the date table 'dData[Ano]': It however shows a year in the future, since 'dDatas' goes all the way through the end of 2024 (it needs to continue this way). But I need this slicer to show only the current year plus all available past years. How can I set a dynamic threshold that could make the slicer hide this and any other future years that might come up? I tried playing with the filter pane but couldn't find anything that could get that done. One of the filter pane options is to set a top or bottom value, so I created a measure DISTINCTCOUNT( dData[Ano ) to dynamically set this value, but when I place it on the well the "Apply filter" is still greyed out so that's also not working for me. And I tried creating a measure with GENERATESERIES but the slicer "Field" pane won't even take this measure when I select it. I get the sense this should be a simple fix, but I ran out of options to the best of my (limited) knowledge and really need that future year (2024 on this case) gone from the slicer. Please help!
Best way to calculate measure line by line ?
Hi everyone ! I'm in a complex DAX time-optimization operation today, and I need your help ! (sorry for the syntax errors, I'm not english native-speaker) For context : We are using measure to aggregate gross revenue and visits in the different stores (it's basically sums) The stores are then grouped by if they are physical and selling only one brand, physical selling several brand or online stores With these measures, we then calculate the progress for each (this year's sum versus last year's sum) And finally, with the progresses we calculate a delta between gross revenue progress (GMP) and visits progress (VP) (It's basically GMP - VP) The main problem is that on the delta, I have to exclude the online stores (because visits doesn't make sense in an online store) And because of this exclusion, the measure takes a very long time (1m20) to calculate and display in a table in my report The DAX formula used today to achieve the point is : SWITCH(SELECTEDVALUE(Store[Format]), "physicalOneBrand", CALCULATE(([GRP]-[VP]) * 100, FILTER(Store, Store[Format] = "physicalOneBrand")), "physicalSeveralBrands", CALCULATE(([GRP]-[VP]) * 100, FILTER(Store, Store[Format] = "physicalSeveralBrands")), CALCULATE(([GRP]-[VP]) * 100, FILTER(Store, Store[Format] = "physicalOneBrand" || Store[Format] = "physicalSeveralBrands" ))) Is there a better way to calculate this delta without taking 1min+ to display the result ? Thanks in advance for your help, I really have no solution If the explanation isn't clear, tell me and I'll try to give you more mocks to help the understanding !
