Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

distinct count and group by

I want to find out what % of customer order by Region and Tier.    I can get the count of how many order by dropping to value and changed to distinct count,  But i cant get the total count of each...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 


    The measure should something like the follow: 

     

    Count OF Cust Ordered = CALCULATE(DISTINCTCOUNT('Table'[Cust]),ALLEXCEPT('Table','Table'[Tier],'Table'[Region]),FILTER('Table','Table'[Order]<>BLANK()))

% = [Count OF Cust Ordered]/COUNT('Table'[Cust])

     

    Matrix:

     

    Community Support Team _ Paul Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 


The measure should something like the follow: 

 

Count OF Cust Ordered = CALCULATE(DISTINCTCOUNT('Table'[Cust]),ALLEXCEPT('Table','Table'[Tier],'Table'[Region]),FILTER('Table','Table'[Order]<>BLANK()))

% = [Count OF Cust Ordered]/COUNT('Table'[Cust])

 

Matrix:

 

Community Support Team _ Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly