Forum Discussion

Sriku's avatar
Sriku
Helper IV
6 years ago
Solved

count distinct customer using countif formula

Hi Team,

 I am trying to count distinct customer discount percentage is > 15% same "COUNTIF(M15:M425,">"&15%)".

 

while applying filter formula like sales date; it doesnot give proper result count
 
How to achieve this? Please assist
 
Regards,
Srikant
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Sriku ,

     

    Sorry for that we have a little confused about your issue.

    How percentage is calculated?

    We create a sample, and use the following measure to get the count.

     

     

    Count = 
CALCULATE(DISTINCTCOUNT('Table'[customer]),FILTER('Table',[%]>=0.15))

     

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Sriku , with few assumptions measure for discount percentage, is [discount percentage] , and customer group by

     

    countx(filter(summarize(Table,Table[customer], "_1", [discount percentage]),[_1]>.15),[customer])

    • Sriku's avatar
      Sriku
      Helper IV
      6 years ago

      Hi Amit,

       

      Getting a error message "Too few agruments were passed to countx function.The minimum count of hte function is 2

       

      Regards,

      Srikant

      • v-zhenbw-msft's avatar
        v-zhenbw-msft
        Community Support
        6 years ago

        Hi Sriku ,

         

        Sorry for that we have a little confused about your issue.

        How percentage is calculated?

        We create a sample, and use the following measure to get the count.

         

         

        Count = 
CALCULATE(DISTINCTCOUNT('Table'[customer]),FILTER('Table',[%]>=0.15))

         

         

        If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

        It will be helpful if you can show us the exact expected result based on the tables.

         

        Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

         

        Best regards,

         

        Community Support Team _ zhenbw

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        BTW, pbix as attached.