Forum Discussion
Power BI
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
From the power query editor convert the data type of both columns to Whole Number
7 Replies
FreemanZSuper User
hi kanaga_raj_2
what do you expect out of the data in the 3rd screenshot?
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.
- tamerj1
Community Champion
Hi kanaga_raj_2
change the summarization from count to sum.
there is only two summarization (count and count distinct)
- tamerj1
kanaga_raj_2
From the power query editor convert the data type of both columns to Whole Number
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.
