Power Pivot Table Does not count rows with blank adjacent columns

[AEAA]

Hi all,

I have this data, where all the rows with "Response" as "Distributed" have only blank cells next to it:

Role	Experience	Response	Index
		Distributed	1
Engineer	≤ 10 Years	Complete	2
Engineer	≤ 10 Years	Complete	3
Technician	> 10 Years	Complete	4
Technician	≤ 10 Years	Complete	5
Engineer	≤ 10 Years	Complete	6
		Distributed	7
Manager	> 10 Years	Complete	8
Engineer	≤ 10 Years	Complete	9
Engineer	≤ 10 Years	Complete	10
Technician	≤ 10 Years	Partially Complete	11
		Distributed	12
		Distributed	13

And I have created a pivot table summarizing the Count of Response in which I see:

Row Labels	Count of Response
Distributed
Partially Complete	74
Complete	469
Grand Total	543

Where Distributed should actually be: 451 and Grand Total: 994. However the row is empty as there are empty cells next to it.

I have a relationship in the Data Model where I relate the Following "Response" Table with my main Table "Response":

Response
Distributed
Partially Complete
Complete

I would like to show 451 for distributed and then if I filter to a point where Distributed does not exist then I would like to show 0 or blank.

Thank you.

 

[Alex Blakenburg]

Is your pivot based on the data model ?
Can you show me your Home > Diagram View screen.
Can you also show me your Pivot Table Navigation screen with the 2 tables expanded and showing the available fields ?

 

[AEAA]

Is your pivot based on the data model ?
Can you show me your Home > Diagram View screen.
Can you also show me your Pivot Table Navigation screen with the 2 tables expanded and showing the available fields ?

Hello! Thanks for the response. I realized what the problem was.

My pivot table is based on the data model and the two categories were properly related. The problem was that I had a slicer with the Properties (Hide items with no data) and the Blank option was not being selected. Once I removed all the filters I got the result that I wanted.

 

[Alex Blakenburg]

Thanks for letting me know. Given that your post details how you solved the problem you are allowed to and in fact encouraged to mark your post #3 as the solution, so that it may help others.