Forum Discussion

neillago's avatar
neillago
Regular Visitor
5 years ago

Help with DAX CALCULATE returning incorrect blanks

Hello,   I am having trouble getting my measure to work.  I am using DirectQuery on a streaming Power BI dataset.  A sample of the data looks like this:    [Table] DateTime MillNo ErrorCode...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi neillago 

Have you looked at my PBIX file? I can't reproduce the issue wth the sample data you provided.

Can you double check your data for blanks/null/invalid data in the ErrorCode column?

Regards

Phil

neillago's avatar
neillago
Regular Visitor
5 years ago

I have run tests.

 

I created a new Power BI dataset and pushed 5 values to it and the calculation worked.

 

I created a new file using my full dataset from the original file and the issue remains.  It is a streaming dataset with 4900 rows and about 200-500 added a day.

 

I got this error when adding the new measure to a table: