Forum Discussion

Tribal's avatar
Tribal
Frequent Visitor
2 years ago

Unable to locate error - simple hierarchy

Currently some of my slicers are returning an error. I've been trying to locate the error, but I'm not sure what "Query (14, 55)" or "Query (11, 55)" is referring to here, and therefore I have no clue where to look. The slicer is using a simple year-month hierarchy, where both year and month are text values, which is therefore adding to my confusion, since the mentioned function 'CONTAINSROW' doesn't seem relevant for this field.

 

I hope someone can point me in the right direction

 



 

 

Need Help

2 Replies

  • mh2587's avatar
    mh2587
    Icon for Super User rankSuper User
    2 years ago

    I think you are facing data type error in one of measure 

    • Tribal's avatar
      Tribal
      Frequent Visitor
      2 years ago

      I agree, that's what it looks like, but also where my confusion is. The slicer I'm using is not using any measures, but only a hierarchy text field. 


      That makes it alot harder to look in the correct location. My guess was that the numbers in brackets (14, 55) are referring to where the error is coming from, but I don't know how to interpret these numbers unfortunately