The query referenced does not hold any data

[Anonymous]

Hi Everyone,

I need a help,please.

I have the following DAX that calculates a calculated table

UNION (
SELECTCOLUMNS (
ALLNOBLANKROW ('Rate Code'[RATE_CD]),
"Ranking name", 'Rate Code'[RATE_CD],
"Ranking group", "Top Rate Codes"
),
{ ( "Others", "Others" ) }
)

When I run this, it gives an error:

The query referenced calculted table does not hold data because evaluation f one of the rows caused an error.

Can someone please help me understand why it is throwing this error?

Thank you in advance.

Regards,

Mithilesh

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I think it is working in my pbix file.

Please check the below pictures and the attached pbix file.

Or, please share your sample pbix file's link here, and then I can try to look into it.

[Anonymous]

Hi @Jihwan_Kim ,

Can you please check in case there are blanks in rate_code field?

Thanks,

Mithilesh

[Anonymous]

Thank you, @Jihwan_Kim 

On my end, this table is created in tabular editor and is packaged within a model in Azure Analysis Services.

Can you please advise if I should do something differently to prevent this error? I sent you a message. Please let me know if it's possible.

Thanks,

Mithilesh