Forum Discussion
Filter Not working on Dax
Super UserYour 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.
This PBIX file is for report server.
i am again clarifying my issue:-
-I need to identify those site where the sales are going continuous down over a specified period, based on the monthly selection.
For instanceif I select six months, I want to find those sites where sales have consistently decreased for all six of those months, resulting in a count of six consecutive decreases.
But with this count 6 i am also getting those site which is continously down sales for these selected month 5 times, 4 times, 3 times or 2 times or 1 times.
So here we need filteration if i select 6 month then only those site need to show where sitecount is 6 others need to filter which is not happening.
Also i am giving you the data file to get this load in your own premises and check-
https://docs.google.com/spreadsheets/d/1J0St32wZ3ZqjlQJ8zMkGApAhN8Kl8Zuq/edit?usp=drive_link&ouid=104348883861930142596&rtpof=true&sd=true
If there is any issue to understand or maybe i am not clear, we can connect over a sort call to discuss this.
Thanks for your support!!
So what i have done so far here......
I have Month/year, Sales, Regionhead(which we are not using as of now in this scenario) .
-Since i have Sales so i calculated the previousmonth sale for site wise using measure
-Now i have compared site currentsales Vs Previousmonth sale and if currentmonth sale<Previousmonth sale then i have kept them as a degrow site.-Later on i used this as filter pane and only filtered those site where the sales is down compare to previos month
-Now suppose i have selected 6 month from month/year slicer then in table chart i will have only 6 month data and since i have filtered only those site where sales is down compare to last month in filter pane so now i can count the site.
-If any site is 6 times avaialble in this table chart mean that is what i am looking for-- continous sale is down
- that's why i used the site_count dax function which is aplicable to count the site in that table chart only
-Now in selection of any month i can get to know how many month i have selecetd and now i want those site where the countmonth=count_site
-Here i have got the result also but the main issue is that i am getting those site where sales is down for all month
In Summarize if you will see in my PBIX file so i have selected 6 month and those sites you can check in table chart where the site_count is showing 6 those are my result which is 100% correct but if you scroll down then you are getting site_count with 5, 4, 3,2,1 so we want to exclude these sites only because we have selected 6 month so want only those sites where sales down for 6 times.
Same i will select 5 times or 8 times then only those site want where sales down for 5 or 8 times rest we want to exclude.
Requesting to provide your available time to connect so that we can discuss and get a proper resoultion over this.
Thanks again to lookingup this challenging issue.
- lbendlin
I don't have a test setup for Report Server. I hope someone else can help you further.
I Think you need not to do anything extra.
You can get the data and also can load into power BI desktop and then you can try your own method.Because it's seems very complex to me. I think if you will try may be you can get the desired output.