Forum Discussion
neillago
5 years agoRegular Visitor
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...
PhilipTreacy
5 years agoSuper User
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
5 years agoRegular Visitor
I did look. Thank you. It is still not working on my file. I sent a PM with the full file.
the data does not have blanks, Nulls or invalid data.