How to keep the blank/null value when using summarize function

[Anonymous]

I have a companyTable with [Country] column, the blank/null value is included.

However, the SUMMARIZE function always excludes it, anyone know how to keeps the blank/null value in the query below?

EVALUATE

VAR companyTable = ....

SUMMARIZE(
    companyTable,
    [Country],
    "Sales Amount",
    [Sales Amount]
)

I could not use the SUMMARIZECOLUMNS as it does not support the table variable.

Thank you.

[Anonymous · Accepted solution]

i have tried in my data and i am getting blanks.

COULD you please share your sample dataset.

Thanks,

Pravin

[Anonymous]

Hi @Anonymous , sorry, I have overlooked the query, it has filtered the blank record.

Please ignored my question.

[Anonymous]

if it resolves your problem mark it as a solution so that it will be helpful for others.

Thanks,

Pravin