Couldn't load the Data for this visual error

[Justas4478]

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 not working. Since there is other older report in the bi online that is using same measure just with different column and it doesnt give this error when using measure in the visual. I did try some of the solutions that I could find in the forums but they didnt work for me. Anyone know what could be the problem and how to fix it? Thank you.

[lbendlin]

Quite contrary - it is better to use columns (and the calculation steps) than existing measures when creating a new measure

[lbendlin]

That's generally the recommendation. Instead of nesting measures it is better to be verbose in each measure definition (ie write each measure from scratch). That way you can avoid potential pitfalls like circular references or excessive looping.

[Justas4478]

So the column cant be used in the measure that I am trying to create?

[Justas4478]

For some reason when I add this filter to the visual the measure starts working(See the screenshot.)

If I change it to weeks from Days it breaks the measure. Does anyone know why it starts working when there is days set in this filter and why it doesnt when date is more than 1 day.

[lbendlin]

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

[Justas4478]

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]

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]

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?