PivotTable "Show items with no data" not working with Data Model

[AEAA]

Hi all,

I currently have a PivotTable linked to a Data Model and when I go to Field Settings -> Display -> Show items with no data is greyed out:

My problem is that I have a data with the following categories: 1) Distributed, 2) Partially Complete, 3) Complete

My full results are:

As soon as I filter the data with a Slicer, For example: Out of 994, a group of 24 people have 0 Distributed 1 Partially Complete and 23 Complete. But the PivotTable shows like this:

(NO DISTRIBUTED)

And when the value is queried

I would like to show distributed as either blank or zero in my PivotTable. All my PivotCharts get ruined because of this.

Thank you for your help.

 

[AEAA]

Does anyone have any advice on this one? I still haven't been able to figure it out. Thanks.

 

[AEAA]

This video solves it:

Create table with all your fixed categories -> Load to Data Model -> Create relationship with the category -> Create a measure with:

=IF(ISBLANK(COUNT(Demographics[Response]));0;COUNT(Demographics[Response]))

OR

=IF(ISBLANK(SUM(Demographics[Response]));0;SUM(Demographics[Response]))