Forum Discussion

sofias's avatar
sofias
Frequent Visitor
4 years ago

Help with distinct calculate on 2 columns

I have a table with 2 columns. "Sales Rep" and "Battle Name" as following sample:   Sales Rep Battle Name [email protected] LESS_L2W_3_ORDERS [email protected] NOT_ACTIVE_L13W 0001...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

1. create a disconnected table

 

 

Battles = GENERATESERIES(1,6)

 

 

2.  for each value of this table, compute the number of reps that fall into that bucket. That can be done as a measure or a calculated column - the example here is for a calculated column.

 

 

#SR = 0+countrows(filter(summarize('Table','Table'[Sales Rep],"Battles",count('Table'[Battle Name])),[Battles]=[Value]))

 

 

Lastly, display the result in a table.  Do not summarize [Value], but show items with no data.