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
Super User
5 years ago

Hi neillago 

Are the error codes numbers or text?

Regards

Phil

neillago's avatar
neillago
Regular Visitor
5 years ago

Unfortunately not. 

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    neillago 

    Sorry?  Which one?  Are they numbers or text?

     

    Please download this sample PBIX.

     

    I can't reproduce your issue, it works for me.  See my file and check it against yours.

    Please link to your PBIX if you can't get it working.

    Regards

    Phil

     

    • neillago's avatar
      neillago
      Regular Visitor
      5 years ago

      Sorry.  The error codes are data type Decimal number with Whole number formatting applied.