Status:
Done
Urgent!! Dax Help Required For calculation
Hi Links Team PBCommunity PBICommunity Issue :- I have site, month/year, Sales and region head column in my Table. Now i have to find out those sites where the sales are going continous down ...
Hi @ v-tianyich-msft
Let's say i have selected month Apr to Oct 23 then the total month count is 7 and you can check those sites are coming in my table colum(Site_count) 7 mean these sites sales have been down in these all selected month. which is result is coming correct.
But aswell as 7 you can check in column Site_count those sites are coming where sales were down 6 times, if you will scroll down then you will get 5 times, 4 times also record
So we want to filter this that if i select 7 month then site_count column should contain only 7 times down site not others.
If you have any issue you can share your available time for a short call and we can discuss over this.