SUMMARIZED Table Visual

[munirtrad]

Hi all,

After creating a SUMMARIZE "table" with 2 columns:

COLUMN 1: Article numbers (all distinct)

COLUMN 2: (Expression from SUMMARIZE formula) -> Values that goe from 0/Blank to 400.

When I put a visual based on that table to show me a COUNT of the Article Numbers (COLUMN 1) with "0/Blank" it counts to 0 (even though there are plenty). When I ask it to COUNT articles with values greater than 0 it works fine.

How can I get my visual to count the second column (Expression from SUMMARIZE formula) with values 0. It seesms like they don't exist.

Thanks.

[v-easonf-msft]

Hi， @munirtrad 

What fields are used in your table  visual? Can you show a screenshot of the table visual?

In addition, please check whether it may be caused by the option 'show items with no data'.

Best Regards,
Community Support Team _ Eason

[parry2k]

@munirtrad so you are using a table visual, putting formula column and then count of articles? And you are saying for blank rows it shows no count of articles although you see it in the calculated table, correct?

[munirtrad]

Hi ! Correct! I choose table visual and for example simply put COUNT OF ARTICLES as a value. Even just there I only see the count for the number of articles on a row where the number is other than 0 or blank. It doesn't even show the number of 0-value articles in the total. I have tried everything and I am getting to a point where I think this is happening because the 0/blank values are in the "EXPRESSION" part of the SUMMARIZE table formula. It's to me like anything with a 0 or blank value on the EXPRESSION stops existing.