Measure Product Distribution

[tl5970]

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

[v-piga-msft]

Hi @tl5970,

I'm a little confused about your scenario.

If it is convenient, could you share some data sample as table and your desired output so that I can understand better and help further on it?

Best  Regards,

Cherry

[tl5970]

Hi @v-piga-msft,

Thanks for your reply. The desired output is "Distribution" header in 5th column. But the incorrect data I get was in column 6th.

[v-piga-msft · Accepted solution]

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]

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