The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Dear Ashish,
Hello All
Hope some one could help me please. I really need some help to count the # of points in each of the quardrants in the visual below. I have attached 2 visuals , the 2nd one is the data that is the tabular version of the data in the scatter plot. All are calculated measures except the store list. Please if you could respond.
A store in Quadrant 1 ( red zone) is a store if its productivity index is lower than Target productivity Index ( 113% ) and lower than Last Year Productivity Index ( 111%). I was able to create the quadrant and visualize it in scatter plot but I now need to identify those stores separately and do calculations based on that.
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
10 | |
7 |