Forum Discussion

oalgarvio's avatar
oalgarvio
Frequent Visitor
2 years ago
Solved

Using variable slicer to filter multiple columns of a table

I need a dynamic slicer (week number of the year) to filter 6 columns (6 charts) of values above the slicer value.   I tried to create a parameter to use in the slicer with a starter value of 1, en...
Need Help
  • MP-iCONN's avatar
    MP-iCONN
    2 years ago

    I will throw this out there...What if you try SUMX?

     

    Measure = IF(SUMX(table1,table1[column A])>= Parameter Week [Parameter Week value],1,0)

MP-iCONN's avatar
MP-iCONN
Resolver I
2 years ago

I might be way off but wouldn't the Parameter Week Value measure be this....

 

Parameter Week Value = SELECTEDVALUE('Parameter Week'[Parameter Week], 53)
oalgarvio's avatar
oalgarvio
Frequent Visitor
2 years ago

That is how it is, I copied and pasted and forgot to change, sorry, corrected now

  • MP-iCONN's avatar
    MP-iCONN
    Resolver I
    2 years ago

    I will throw this out there...What if you try SUMX?

     

    Measure = IF(SUMX(table1,table1[column A])>= Parameter Week [Parameter Week value],1,0)

    • oalgarvio's avatar
      oalgarvio
      Frequent Visitor
      2 years ago

      That is working when I display it in a table but not in a donut chart, which is counting the values of a specific product. In the table I only have an entry (SUMX(table1,table1[column A])>= 37) of a product A, the donut chart should be giving me a value of 1 product A, but it's giving me 22 products A, 22 product B, 21 product C and 8 products D, which is the values without the filter.

       

      I manage to resolve that. You got me the solution, thank you.