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 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