Summarize table with blanks

Question

I am trying to summarize a table with the following code and it gives me only the matching values and not blanks.&nbsp;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.&nbsp;I have isblank conditions in value1 measure but that's not helping.&nbsp;does anyone know how to fix this?&nbsp;SUMMARIZE(&nbsp;Table1, Table1[Category1], Table1[Category2], Value1)&nbsp;Category1squarecirclerect&nbsp;Category2blueorangeyellow&nbsp;&nbsp;Sample TableCategory1&nbsp; &nbsp; &nbsp;Category2&nbsp; &nbsp; &nbsp;Value1square&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5square&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6square&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;orange&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9square&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;orange&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7circle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11circle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;orange&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3circle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;yellow&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2square&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;orange&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9circle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11circle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;orange&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3circle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;yellow&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2

parry2k · Answer

Anonymous&nbsp;what is value1?&nbsp;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 · Answer

value1 is $ amount.

parry2k · Answer

Anonymous&nbsp;where it is coming from? Which table? How tables are related? Did you read this?&nbsp;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 · Answer

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.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;
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 .
&nbsp;
Best Regards
Community Support Team _ Ailsa Tao
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Summarize table with blanks

7 Replies

Related content

Merge Summarize Table

Parameter table dimensions - summarize

SUMMARIZE Table

Parameter in summarize

Summarize average monthly table