Summarize table with blanks

[Anonymous]

I am trying to summarize a table with the following code and it gives me only the matching values and not blanks. 
For example in the sample table below there is no value for square and yellow so summarize will not include that in the summary. I want it to include it and say 0.

I have isblank conditions in value1 measure but that's not helping.

does anyone know how to fix this?

SUMMARIZE( 

Table1, Table1[Category1], Table1[Category2], Value1)

Category1
square

circle

rect

Category2

blue

orange

yellow

Sample Table

Category1     Category2     Value1

square           blue               5

square           blue               6
square           orange           9
square           orange           7

circle             blue                11

circle             orange            3

circle             yellow             2

square           orange           9

circle             blue                11

circle             orange            3

circle             yellow             2

[parry2k]

just wondering why multiple people are asking the same question 🧐

[Anonymous]

Hi @Anonymous 

It seems that when you are in SUMMARIZE, no value for square and yellow, so it is not displayed. I understand it right ?

But my question now is, what is your value1 ? Could you provide detailed information about value1 ? If you don’t provide the original data about the value1 field, we can’t judge that why no value for square and yellow .

Looking forward to your reply .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

do you see the table in my original post? value1 is there in the sample table.

[parry2k]

@Anonymous where it is coming from? Which table? How tables are related? Did you read this? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

There is only 1 table. There are NO other tables. There are NO relationships. I am only summarizing one table. 
Read my post carefully and you'll understand it perhaps. Yes I read you've posted twice already.

[parry2k]

@Anonymous what is value1? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

value1 is $ amount.