Show filtered rows

[Anonymous]

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

[Greg_Deckler]

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

[Anonymous]

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