Forum Discussion

tl5970's avatar
tl5970
Frequent Visitor
8 years ago
Solved

Measure Product Distribution

Hi all, could anyone help me to solve the below measure? total_sales_qty for each store must greate thn 0 thn count as 1. Each Product's distribution will calculate base on the total store's ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi tl5970,

     

    Please try the measure below.

     

    Measure =
CALCULATE (
    COUNT ( 'table'[Store_No] ),
    FILTER ( 'table', CALCULATE ( SUM ( 'table'[Total_sales_qty] ) ) > 0 )
)

    Here is the result output.

     

     

    Best Regards,

    Cherry

tl5970's avatar
tl5970
Frequent Visitor
8 years ago

Hi all, could anyone help me to solve the below measure?

total_sales_qty for each store must greate thn 0 thn count as 1.

Each Product's distribution will calculate base on the total store's sales qty that is more thn 0

What I get is in Red column. Kindly pls help. Thanks in advance