How to get the actual total when selected distinct count in a graph

[Anonymous]

Hi,

I expecting a solution for the following  

On the left, the total 64 is the sum of the item title.

On the right the measure is the distinct count of the item title.  While analysing in deep I find the following

For the right graph, the total 26 is actually the distinct value of the items.  But I want the sum of the intigers whichis actually 64.  PFB, the analysis  for both the graph as table:

Left Table:

Month	Employee	Item	Count of Item Title
June	Adam	Item	1
June	Anastasia	Item 1	1
June	Anastasia	Item 2	1
June	Anastasia	Item 3	1
June	Anastasia	Item 4	1
June	Bill	Item 5	1
June	Bill	Item 6	2
June	Bill	Item 1	1
June	Brian	Item 7	1
June	Chris	Item 7	1
June	Chris	Item 8	1
June	Chris	Item 9	1
June	Chris	Item 3	1
June	Clifford	Item 10	1
June	David	Item 1	1
June	David	Item 1	1
June	David	Item 7	1
June	Helen	Item 11	1
June	Helen	Item 1	1
June	Helen	Item 7	1
June	Helen	Item 12	1
June	Helen	Item 13	1
June	Helen	Item 14	1
June	Helen	Item 15	1
June	Helen	Item 16	1
June	Iulia	Item 17	1
June	Iulia	Item 3	1
June	Jefferson	Item 18	1
June	Jefferson	Item 19	1
June	Jefferson	Item 20	1
June	Jefferson	Item 21	1
June	Jefferson	Item 22	1
June	Jefferson	Item 23	1
June	Joyce	Item 18	1
June	Karen	Item 1	1
June	Kathy	Item 6	1
June	Kaushik	Item 18	1
June	Kaushik	Item 1	1
June	Lou	Item 7	1
June	Manisha	Item 3	1
June	Michael	Item 1	1
June	Michael	Item 1	1
June	Michael	Item 24	1
June	Michael	Item 9	1
June	Mohammad	Item 18	1
June	Mohammad	Item 1	1
June	Padma	Item 7	1
June	Padma	Item 4	1
June	Paul	Item 5	1
June	Raana	Item 1	1
June	Ram	Item 1	1
June	Ravichandran	Item 1	1
June	Ravichandran	Item 1	1
June	Rumman	Item 7	1
June	Rumman	Item 25	1
June	Rumman	Item 1	1
June	Rumman	Item 7	1
June	Rumman	Item 11	1
June	Saravanan	Item 26	1
June	Shashank	Item 1	1
June	Tyler	Item 7	1
June	Vignesh	Item 3	1
June	Waseem	Item 1	1
June	William	Item 1	2
			66

Right Table:

Month	Employee	Item Title	Count of Item Title
June	Adam	Item	1
June	Anastasia	Item 1	1
June	Anastasia	Item 1	1
June	Anastasia	Item 1	1
June	Anastasia	Item 1	1
June	Bill	Item 5	1
June	Bill	Item 5	1
June	Bill	Item 5	1
June	Brian	Item 7	1
June	Chris	Item 7	1
June	Chris	Item 7	1
June	Chris	Item 7	1
June	Chris	Item 7	1
June	Clifford	Item 10	1
June	David	Item 1	1
June	David	Item 1	1
June	David	Item 1	1
June	Helen	Item 11	1
June	Helen	Item 11	1
June	Helen	Item 11	1
June	Helen	Item 11	1
June	Helen	Item 11	1
June	Helen	Item 11	1
June	Helen	Item 11	1
June	Helen	Item 11	1
June	Iulia	Item 17	1
June	Iulia	Item 17	1
June	Jefferson	Item 18	1
June	Jefferson	Item 18	1
June	Jefferson	Item 18	1
June	Jefferson	Item 18	1
June	Jefferson	Item 18	1
June	Jefferson	Item 18	1
June	Joyce	Item 18	1
June	Karen	Item 1	1
June	Kathy	Item 6	1
June	Kaushik	Item 18	1
June	Kaushik	Item 18	1
June	Lou	Item 7	1
June	Manisha	Item 3	1
June	Michael	Item 1	1
June	Michael	Item 1	1
June	Michael	Item 1	1
June	Michael	Item 1	1
June	Mohammad	Item 18	1
June	Mohammad	Item 18	1
June	Padma	Item 7	1
June	Padma	Item 7	1
June	Paul	Item 5	1
June	Raana	Item 1	1
June	Ram	Item 1	1
June	Ravichandran	Item 1	1
June	Ravichandran	Item 1	1
June	Rumman	Item 7	1
June	Rumman	Item 7	1
June	Rumman	Item 7	1
June	Rumman	Item 7	1
June	Rumman	Item 7	1
June	Saravanan	Item 26	1
June	Shashank	Item 1	1
June	Tyler	Item 7	1
June	Vignesh	Item 3	1
June	Waseem	Item 1	1
June	William	Item 1	1
ACTUAL RESULT: 26 (TOTAL is Taken as all of distinct Item Title)	64

Kindly help me with the solution

BR

GOPAL

[v-shex-msft · Accepted solution]

HI @Anonymous,

I'd like to suggest you create a custom report tooltip to show the actual total values when you hover the mouse on data labels.

Using report tooltip pages in Power BI - Power BI | Microsoft Docs

Regards,
Xiaoxin Sheng