Power BI

[kanaga_raj_2]

Hi Friends,

I hope all are good and healthy.

Can anyone please clear up my problem?

Here I attach the three screenshots, the problem Is that have a total of 10 calls in screenshot 1.

The 2nd screenshot's total counts were more than 10 (the value is 20).

The 3rd screenshot is my data in the table.

What I want is based on the DNIS i want exact 10 count.132

Thanks and please help me

[kanaga_raj_2]

there is only two summarization (count and count distinct) 

what I want is for my total calls are 10 but the total values are different. 

here I attach the complete screenshot for your reference.

[tamerj1]

Hi @kanaga_raj_2 

change the summarization from count to sum. 

[kanaga_raj_2]

there is only two summarization (count and count distinct) 

[tamerj1 · Accepted solution]

@kanaga_raj_2 
From the power query editor convert the data type of both columns to Whole Number

[kanaga_raj_2]

yes, this buddy my problem is resolved thanks

[FreemanZ]

hi @kanaga_raj_2 

what do you expect out of the data in the 3rd screenshot?

[kanaga_raj_2]

hi @FreemanZ 

there is only two summarization (count and count distinct) 

what I want is for my total calls are 10 but the total values are different. 

here I attach the complete screenshot for your reference.