Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Show filtered rows

Hello to everyone, I have an issue with a pivot table. I want to show a row which is filtered out. I use a slicer to filter the case. For the Medium size devices, there is no incident case. So the row with CH and Medium will not be shown. Can I create a measure which show the row anyways with 1 as a value?

Thank you for your help.

Best regards

 

 

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous Probably. Try using ALL to remove filtering by slicers. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello Greg,

       

      thank you for your reply. I tried a measure with calculate and all. I want to force the pivot to show the filtered row with CH and Medium.

      Best regards