Forum Discussion
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...
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)
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)
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.