topic Re: Power BI in DAX Commands and Tips

Power BI

kanaga_raj_2 — Thu, 04 May 2023 13:03:31 GMT

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.

Thanks and please help me

FreemanZ — Thu, 04 May 2023 14:36:02 GMT

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

tamerj1 — Thu, 04 May 2023 16:27:09 GMT

change the summarization from count to sum.

kanaga_raj_2 — Fri, 05 May 2023 04:20:43 GMT

there is only two summarization (count and count distinct)

kanaga_raj_2 — Fri, 05 May 2023 04:30:11 GMT

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.

kanaga_raj_2 — Fri, 05 May 2023 04:29:04 GMT

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 — Fri, 05 May 2023 06:03:42 GMT

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

kanaga_raj_2 — Fri, 05 May 2023 10:49:41 GMT

yes, this buddy my problem is resolved thanks