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 Anonymous ,
Based on your description and your sample, you are trying to determine whether site is continuously declining or not by Sales_Decrease, I made some attempts and you can check the following results:
Result = var _r=SUMX(ALLSELECTED(Degrowing_TB[Month/Year]),[Sales_Decrease])
return IF(_r<>[site_Count],1,0)
Just use this measure and apply it to the VISUAL selection value of 0
Hope it helps!
Best regards,
Community Support Team_ Scott Chang