Creating Measures on data from a Sharepoint List

[Anonymous]

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")

I have now created a Form that connects to Sharepoint via Flow.

So all my data is now held on the Sharepoint List.

I am now in the process of recreating the dashboard with the new connection - I opted for recreating it, for more experience but also because Sharepoint has abbreviated/changed some of the names of the columns.

When attempting to use the above formula to recreate the measure I am met with the following error message:

'A single value for column 'DateofAssessment' in table 'Customer Satisfaction Responses' cannot be determined. This can happen when a measure formula referes to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result'

How can I get round this?

The data is the same data, and also has the same formatting.

The only difference is that one is Excel --> Power BI and the other is Forms --> Flow --> Sharepoint --> Power BI

I am totally stumped and have no idea how to fix this.

If you need examples, please let me know.

Any help would be great.

Thanks,

Chris

[rajendraongole1 · Accepted solution]

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]

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!