How to show the count inside the bubble of a scatter chart

[POSPOS]

Hi all,

I have a requirement to show the count inside the bubble of scatter plot. For this I am trying to add a measure in the "Values" and turn on the category label , but "Values" does not accept any measures.

The DAX used for the measure is 

measure =
SUMX(
    VALUES([department]),
    CALCULATE((distinctcount(id),end_date >= DATE(2022,07,01))
   )

I tried to use the same calcuation in a calculated column but it is giving incorrect results and showing the same values for all bubbles.
My requirement is to show as below.

Can somone please suggest on how to achieve this?

Thank you.

[ExcelMonke]

Ah, I see. Sorry for misunderstanding in the beginning. The only other option I see around this is to either:
Convert your measure to a valid column calculation, or create a summarize table with your measure as a column, and use the columns from the summarize table to create your chart. 

There may be a more efficient way, but this is my only workaround idea at the moment.

[POSPOS]

@ExcelMonke  - As mentioned in my question, Converting measure to a calculated col is not giving me the right results. 

[ExcelMonke]

Because this chart does not come "standard" with PBI, it is a little challenging to figure out where the measure should go. Typically, you can add labels within the "Format your visual" section. Is there an option for this in there?

[POSPOS]

@ExcelMonke  - No, we do not have any such option under format.

[ExcelMonke]

What options do you have in your visual format?

[POSPOS]

@ExcelMonke  I am using the standard scatter chart. And this visual does not have any option to display the field used in the "size" to show as data label.

[ExcelMonke]

I would not use a calculated column for this. Create a new measure, something like "Bubble Label", and add the measure to a label/values for the bubbles. 

[POSPOS]

@ExcelMonke :
When I try to add the meausre to the "Values", it does not accept. Values only accepts columns

[ExcelMonke]

You are using a SUMX function which doesn't quite work for this visual. 

Consider using the DAX expression you have, just without the SUMX (i.e. just the calculate expression).

[POSPOS]

@ExcelMonke  - I created a calculated col using just the expression without SUMX and it gives 1 for all the values.