cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

COUNTING NO. OF TIMES A DISTINCT VALUES OCCURS IN A COLUMN

IMG_20171122_212444_HDR.jpg

 

IMG_20171122_135241.jpg

 HERE FIRST TWO COLUMNS ARE THE TOTAL COUNT , WHILE THE THIRD COLUMN IS NO. OF TIMES UNIQUE INBOUND & UNIQUE OUTBOUND CALLS .. WHICH IS GREATER THAN THE TOTAL .. PLEASE HELP I AM NOT ABLE TO FIGURE OUT HOW TO CORRECT THIS

 

3 REPLIES 3
Regular Visitor

IMG_20171122_212444_HDR.jpg

 

IMG_20171122_135241.jpg

 HERE FIRST TWO COLUMNS ARE THE TOTAL COUNT , WHILE THE THIRD COLUMN IS NO. OF TIMES UNIQUE INBOUND & UNIQUE OUTBOUND CALLS .. WHICH IS GREATER THAN THE TOTAL .. PLEASE HELP I AM NOT ABLE TO FIGURE OUT HOW TO CORRECT THIS

 

Memorable Member
Memorable Member

You can change counts to count(Disctinct) from the menu on the Value for the table fields.

It's also possible to change the default summarization to count(Distinct)

 

That is what i am using Count(Distinct) for calculating count of unique values in the 3rd Column .. But it is not giving the correct values .. The problem above remains the same.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors