Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Combination Summarized and ALLSELECTED function not working

Hi all,    I am dealing with the following Challenge. I am trying to determine the number of SKUs within a category that are not reaching the 15% NOS contribution target. It sounds quite easy. Howe...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi all,
    I found a solution for my issue. The thing that I had to do is creating a variabe outside the summarize function. In this way, the allsellected function was not ignored anymore since it was fixed.

    I used the following DAX formula:

    Solution =
    var var1 = CALCULATE(sum(Sheet1[NOS]), ALLSELECTED(Sheet1))
    return
    sumx( SUMMARIZE(Sheet1, Sheet1[SKU], "below threshold",
    if(
    DIVIDE(
    sum(Sheet1[NOS]),
    var1)
    < 0.15,1,0)), [below threshold])
     
    Hopefully it will help someone that encounters a similar issue
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jihwan_kim,
    Thanks for your reply. However, it does not solve my issue. The issue that I encounter is that my counter is not working properly. It only works in the row total but it isn't able to count the number of skus below threshold per category. eg, in example1 without filters, it should result in counter = 1 for category A,B and C. and in example2, incl filter category is not A, it should give 1 only for category B