Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating Measures on data from a Sharepoint List

Hi all,   I have a dashboard built on an excel sheet and it works fine. There are many measures created on it and as expected they work For Example:  Month = FORMAT(Sheet1[Start time], "MMMM"...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • rajendraongole1's avatar
    rajendraongole1
    6 years ago

    Looks like you have created a measure instead of a calculated column. If you use the same exact code, but as a calculated column, you shouldn't have an issue. The problem is that measures are calculated over the entire data set unless otherwise given a filter context. So the error message in that case is accurate.

rajendraongole1's avatar
rajendraongole1
Super User
6 years ago

Looks like you have created a measure instead of a calculated column. If you use the same exact code, but as a calculated column, you shouldn't have an issue. The problem is that measures are calculated over the entire data set unless otherwise given a filter context. So the error message in that case is accurate.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for this!

    It worked as a column - but now I am wondering why it worked as a measure before, yet it wont now?

    That's a side note

     

    I'm just glad that doing it as a column is now working!

    Thanks for your help!