Forum Discussion

Ramgopal_PBI's avatar
Ramgopal_PBI
Frequent Visitor
2 years ago
Solved

Caluclate unique customer count

Hi, A customer is purchasing products from multiple distributors. if  morethan 80%  value is purchased from one distributor then the customer is unique to that distributor. As shown in the below tab...
DAX
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi Ramgopal_PBI ,

     

    You can try below measure.

     

     

    No of Unique Customers = 
COUNTROWS(
    FILTER(
        ALLSELECTED('Distributor Sales'[Customer]),
        CALCULATE(
            DIVIDE(
                SUM('Distributor Sales'[Total Sales]),
                CALCULATE(
                    SUM('Distributor Sales'[Total Sales]),
                    ALLSELECTED('Distributor Sales'[Distributor])
                )
            )
        )>0.8
    )
)

     

    Please mark this as solution and give Kudos, if this helps resolve your issue.

     

    Thank you~

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Hi Ramgopal_PBI ,

 

You can try below measure.

 

 

No of Unique Customers = 
COUNTROWS(
    FILTER(
        ALLSELECTED('Distributor Sales'[Customer]),
        CALCULATE(
            DIVIDE(
                SUM('Distributor Sales'[Total Sales]),
                CALCULATE(
                    SUM('Distributor Sales'[Total Sales]),
                    ALLSELECTED('Distributor Sales'[Distributor])
                )
            )
        )>0.8
    )
)

 

Please mark this as solution and give Kudos, if this helps resolve your issue.

 

Thank you~