topic Re: NEED HELP PLS - on counting the data points on the scatter plot in DAX Commands and Tips

NEED HELP PLS - on counting the data points on the scatter plot

Anonymous — Sun, 16 Apr 2023 01:09:51 GMT

Dear All,

Hope you 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. Ideally, if we can create a filter of the quadrants to select the stores to focus on one quadrant for further analysis, would be great.

Ashish_Mathur tamerj1 mwegener amitchandak Greg_Deckler @lbendlin

Re: NEED HELP PLS - on counting the data points on the scatter plot

Ashish_Mathur — Sun, 16 Apr 2023 01:42:27 GMT

Hi,

From the table that you have posted, my guess is that the Target and Last year productivity index will remain constant at 113% and 111% for any store/city/state etc. If my assumption is correct, then share the download link of the PBI file and a table with 4 column

Lower limit of productivity index
Upper limit of productivity index
Lower limit of LY productivity index
Upper limi of LY productivity index

Re: NEED HELP PLS - on counting the data points on the scatter plot

Anonymous — Sun, 16 Apr 2023 01:50:11 GMT

Hi Ashish_Mathur , thanks for your reply. This threshold that defines the quadrant changes with the selection I make by Country or other dimensions. All the columns in the visual I selected are all measures. There is actually no table - the table is just a tabular representation of the scatter plot.

Also, Lower & Upper limit depends on the selection I make.

Let me know if you still need what you asked for.

Re: NEED HELP PLS - on counting the data points on the scatter plot

Ashish_Mathur — Tue, 18 Apr 2023 02:23:59 GMT

Hi,

I may be able to count the points in each quadrant but i don't think i can create a slicer. If you are OK with that solution, then share the download link of the PBI file.

Re: NEED HELP PLS - on counting the data points on the scatter plot

mwegener — Tue, 18 Apr 2023 10:36:08 GMT

Hi Anonymous,

I think you can filter the stores by the measure "CF Quandrants" and then do your further calculations.
If you provide an example PBIX it will be easier to check.