cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

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

 

Highlighted
Memorable Member
Memorable Member

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

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
Regular Visitor

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

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

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors