Forum Discussion
Post ProdigyCouldn'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 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.
8 Replies
- lbendlin
Super User
I don't think this measure is the culprit. Check the other measures that feed this visual.
Justas4478There 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
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
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?
- lbendlin
Quite contrary - it is better to use columns (and the calculation steps) than existing measures when creating a new measure
