Issue Presenting Data

Hi mclougb6, from a high level modeling perspective, I'd do it this way:

Given the calculation context is one month and one hierarchy :

Compute the total sale for the hierarchy for the month, call this T

For each product in the hierarchy, compute the per-product sum of sales for that month ... call this P

Additionally, for products that have no sales in that month, assign them the value of 0 for P

Then rank these P values into ascending order - ie the worst-performing products are ranked first

Next, compute a running sum for each product, by adding up all the P values for the current product and all the other products that are ranked earlier ... call this R

Now we can compute the bottom-N% position of each product:  N = R / T

All products that are in the bottom 5% of the montlhly hierarchy sale will have N values <= 0.05

Finally, you can count the number of these products per hierarchy per month.

Some DAX gurus in this forum can probably write out a single measure that's shorter than all this ;)