Forum Discussion

niko18033's avatar
niko18033
Icon for Helper I rankHelper I
6 years ago

Column to toggle between single or multiple categories

I want to create a column that allows me to toggle between emails associated with single or multiple clients (categories). I have a stacked column chart with the following fields.   Axis: 'Email' ...
niko18033's avatar
niko18033
Icon for Helper I rankHelper I
6 years ago

Hi Vivek - Thanks for your quick reply. Below is a sample export of the data. The emails which are essentially duplicates in this table (have a row for more than one client) are the ones I want to keep.

 

Request Count is a measure. = DISTINCTCOUNT(requests)

 

EmailClient Request Count
[email protected]Client A 2
[email protected]Client A 2
[email protected]Client A 3
[email protected]Client B 3
[email protected]Client C 2
[email protected]Client D 9
[email protected]Client C 2
[email protected]Client A 3
[email protected]Client C 3
[email protected]Client A 2
[email protected]Client A 5
[email protected]Client A 2
[email protected]Client A 2
[email protected]Client A 3
[email protected]Client D 2
[email protected]Client D 2
[email protected]Client A 2
[email protected]Client A 2
[email protected]Client B 2
[email protected]Client A 2

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
As I said above, you have to add an attribute to your table that for each email will tell you whether it's a 'single' one or 'multiple' one. Then and only then will you be able to slice via this attribute and the x-axis of your visual will adjust accordingly.
  • niko18033's avatar
    niko18033
    Icon for Helper I rankHelper I
    6 years ago

    Thanks for the follow-up, Anonymous . What would be the best way to create such an attribute? Through Power Query Editor and doing a 'Group By' aggregation? Or a conditional column? I was thinking of just writing a DAX column, but am unsure how to define this.