Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
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
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.
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |