Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
First, thank you to all the up-until-now users of this forum-- the community content has helped me out of a number of jams, and I've learned a bunch. I haven't quite been able to successfully search for what's tripping me up here, though.
I'm having a heck of a time computing a particular summary of item sales performance: the goal is to aggregate all active products by fiscal year, and to separate those items into buckets according to their average sales per week, per location. The output should look something like this, in which each of the threshold columns sum to equal a count of total active products:
However, my output keeps turning out like this:
Here's what I have currently for DAX:
Example of the (improperly functioning) threshold calculations:
Solved! Go to Solution.
Hi @wirednorth
You may refer to this post to create the measure.For example:
Count = VAR _table = SUMMARIZE ( 'Data Table', 'Data Table'[FISC_YR_NM], "Avg", SUM ( 'Data Table'[UNITS_SOLD] ) / SUM ( 'Data Table'[ACTIVE_LOCATION_CT] ) ) RETURN CALCULATE ( DISTINCTCOUNT ( 'Data Table'[Item ID] ), FILTER ( _table, [Avg] < 0.1 ) )
If it is not your case,please share a simplified sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
Regards,
Cherie
Hi @wirednorth
You may refer to this post to create the measure.For example:
Count = VAR _table = SUMMARIZE ( 'Data Table', 'Data Table'[FISC_YR_NM], "Avg", SUM ( 'Data Table'[UNITS_SOLD] ) / SUM ( 'Data Table'[ACTIVE_LOCATION_CT] ) ) RETURN CALCULATE ( DISTINCTCOUNT ( 'Data Table'[Item ID] ), FILTER ( _table, [Avg] < 0.1 ) )
If it is not your case,please share a simplified sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
Regards,
Cherie
Cherie,
Thank you for your guidance on this. I was able to get everything working quite quickly with the solution you outlined.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |