Show empty values when selecting 'Show as Percentage of Grand Total'

[SusuYes]

Hello everyone, 

I have the following data where some enteries have no data

When I add 'Count of Name' and show it as a percentage of the grant total, it hides all empty values. See below

How can I make all the IDs show even if there is no data (i.e. show as 0%)? 

[amitchandak]

@SusuYes , Have tried, Show items with no Data

[SusuYes]

THanks for your response. 

Yes I had that already turned on. That's how I was able to get the first screen**bleep** as it is already showing items with no data. When I add another coloumn to the values tab and show it as a percentage of the Grand Total, all empty enteries disappear. 

[amitchandak · Accepted solution]

@SusuYes , That is strange. Can you try your own measure?

divide(count(Table[Value]), calculate(count(Table[Value]), allselected())

[SusuYes]

using my own measure worked. Any idea why is this happening for future reference?