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

summing by unique values

I have a large report pulling from many sources.

 

The report is showing workload by task

 

task a - has its own list to pull from

task b - has its own list as well

task c - has its own list also

 

The problem is my last list is customer service contact

it literally counts type of contact daily ( and via a vlookup assigns a disposition we've created)

So i have about 7 "types" of customer interactions.

 

I need to be able to sum each of these up individually so i can add them to my pie and other graphs on the reports.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: summing by unique values

Hi @devongoble ,

You can consider to add a variable with summarize function to group current row contents by its group, then use iteration functions to summary this variable table.

Sample:

Measure =
VAR summary =
    SUMMARIZE (
        Table,
        [Column1],
        [Column2],
        [Column3],
        "Count", COUNTROWS ( Table )
    )
RETURN
    SUMX ( summary, [Count] )

All the secrets of SUMMARIZE

Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: summing by unique values

HI @devongoble ,

I'd like some sample data to clarify your data structures and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Highlighted
devongoble Frequent Visitor
Frequent Visitor

Re: summing by unique values

Here is a sample of how it looks:

count | Date     | Method

1          4.25.19   Phone

5          4.25.19   Email 

7         4.25.19    Chat

12      4.25.19      Mail

15       4.25.19     Comment Mail

3         4.24.19     Phone

2         4.24.19     Chat

9        4.24.19     Email

 

i know just having this data alone isnt an issue to put in graphs. My problem is I have 7 other unique lists combining into these graphs.

The other lists are unique in that they are for one type of process ( Credit Card recovery, fraud, etc) this interaction log is the only one that has multiple methods in it. and NO it cannot be broken into seperate lists per leadership.

Community Support Team
Community Support Team

Re: summing by unique values

Hi @devongoble ,

You can consider to add a variable with summarize function to group current row contents by its group, then use iteration functions to summary this variable table.

Sample:

Measure =
VAR summary =
    SUMMARIZE (
        Table,
        [Column1],
        [Column2],
        [Column3],
        "Count", COUNTROWS ( Table )
    )
RETURN
    SUMX ( summary, [Count] )

All the secrets of SUMMARIZE

Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors