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
Highlighted
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

 

Highlighted
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)

 

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

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