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

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Just wanted to check if you are trying to do this in excel?

In excel you can create a Pivot table for "Product" column.

 

If this helps please give Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pragati11 No. i am trying to do it in Power BI. just use EXCEL to explain my need. lol... 

 

And no, i need to know what % of Cust order. ( like x% )