Forum Discussion
Solved
Row result filtering
I have elaborated a model of which I have a situation with the measure "% Var Total" this measure has two behaviors one at the detail level (product) and the other in the subtotals depending on the a...
Hi RubenIdx ,
If you don't want to see blank and 0 data, you could configure fields it in the filter pane.
You could use ISINSCOPE() function to keep the orginal total value.
Hi!, thanks for the attention.
The expected result is to avoid or hide rows with no data in the selected periods for example in the next image the rows into the red square has no data because these items had sales along 2018 or among april 2019 and december 2019 and Im comparing jan-march 2019 vs jan-march 2020.
And this is the result I would like to achieve.
Thanks in advance.
Hi RubenIdx ,
If you don't want to see blank and 0 data, you could configure fields it in the filter pane.
You could use ISINSCOPE() function to keep the orginal total value.