Forum Discussion

RubenIdx's avatar
RubenIdx
Helper I
6 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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.

     

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi RubenIdx ,

 

I still don't understand your issue totally, you could show your expected result here.

 

 

  • RubenIdx's avatar
    RubenIdx
    Helper I
    6 years ago

    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.

     

    • v-eachen-msft's avatar
      v-eachen-msft
      Community Support
      6 years ago

      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.