Forum Discussion
Filter Not working on Dax
Use SUMMARIZECOLUMNS, not SUMMARIZE.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi
Please find the atttached PBIX sample file link to get the data and the requirement already i have mentioned above.
Please feel free to revert in case of anything you required.
Thanks in advance for helping me out of this challenging requirement.
https://drive.google.com/file/d/16OM7wFp84AU0a_wktGU6bsMTlv8YxzTB/view?usp=drive_link
- lbendlin2 years ago
Super User
This is much more complex than it may seem. Here is a proposal for a part graphical part code solution using Sparklines and array sorting and switch elimination.
This will work both on the store level and the region head level.
- Anonymous2 years agoNot applicable
Hi Thanks for working over my issue.
But still the issue is not solved.
The requirement is that based on month selection we want only those Site where the sales continously went down.
You can try diffreent approach aswell.
For an example - suppose i selected June 23 to Oct 23 so total month will be 5, so we want only those site where continously sales went down in these selected month.
Let say there is a site 123 and sales of month on monthMonth Sales
June 23 100July 23 90
Aug 23 80
Sep 23 75
Oct 23 72
Here as we can see the sales is continously down so we need to only find these kinds of site based on month selection.
Mean the result should be filtered out dynamically based on number of month selected.
if selected 5 month then need to show those site where 5 times continously sales went down, if selected 6 month or 8 month then need to show only those site where continously 6 times or 8 times sales went down.
Kindly help me here so that i can come out from this strange challenge.
Thanks in Advance!!- lbendlin2 years ago
Super User
Your sample data doesn't support the premise. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.