Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
5 years ago

Couldn't load the Data for this visual error

I have tried to use the measure and I am getting this error.   And this is the measure I am trying to use.  This is how thous columns look in the table views.   I dont understand why it is n...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

I don't think this measure is the culprit.  Check the other measures that feed this visual.

  • Justas4478's avatar
    Justas4478
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    There is no other measures used in the visual on this measure on its own. So it is something with the measure or with the columns maybe.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      5 years ago

      Yes there is. Your screenshot shows a measure inside your measure.

       

      Use Performance Analyzer to grab the DAX query and then use DAX Studio to inspect it.

      • Justas4478's avatar
        Justas4478
        Icon for Post Prodigy rankPost Prodigy
        5 years ago

        The only thing there is other than the measure I could find is this column SalesValue see the attached screenshot. I did try to use the column instead of the measure but I cant get the measure writen right so that it would start working.

         

        They seem to have exact same figures as the measure on the left in the screenshot. Do you know how I should write the measure so that it would work with column in it?