Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count based on multiple criteria

Hello, I am a newbie integrating Power BI at my workplace. Could you please help with a query to sum/count based on multiple criteria.   I have a data set of each customer and  Sales rep assigned ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Please create a calculated column with below formula:

    Count of Sales Unit =
CALCULATE (
    DISTINCTCOUNT ( Table[Customer] ),
    FILTER ( ALLEXCEPT ( Table, Table[Sales Rep] ), Table[Units Sold] >= 1 )
)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Please create a calculated column with below formula:

Count of Sales Unit =
CALCULATE (
    DISTINCTCOUNT ( Table[Customer] ),
    FILTER ( ALLEXCEPT ( Table, Table[Sales Rep] ), Table[Units Sold] >= 1 )
)

Best regards,

Yuliana Gu