Hello,
I need some help to change the value when I click at a slicer.
There are two slicers. When I click at one item in the first slicer, the second will be filtered, and also all the reports of my page.
If there is nothing selected at the second slicers, all the reports will show me the Sum of all them. I need to clear those values and put them equal 0.
I try to creat a new column and calculate something like this: IF (Column = "X";0;Sum(Metric)), but didn't work, because the "Sum(Metric)" won't worry about that column anymore, so everything that I click at that slicer, won't filter anymore, it only shows the sum of everything. And I want to show 0 at only one item of that slicer, the other ones need to keep filtering.
Summing up, if I click at one item at the first slicer, and no item at the secod slicer, I don't want to sum, I want to show 0.
I don't know if I being clear.
Can someone help me.
