Creating Measures on data from a Sharepoint List

Question

Hi all,&nbsp;I have a dashboard built on an excel sheet and it works fine.There are many measures created on it and as expected they workFor Example:&nbsp;Month = FORMAT(Sheet1[Start time], "MMMM")&nbsp;I have now created a Form that connects to Sharepoint via Flow.So all my data is now held on the Sharepoint List.&nbsp;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.&nbsp;When attempting to use the above formula to recreate the measure I am met with the following error message:&nbsp;'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'&nbsp;How can I get round this?The data is the same data, and also has the same formatting.&nbsp;The only difference is that one is Excel --&gt; Power BI and the other is Forms --&gt; Flow --&gt; Sharepoint --&gt; Power BI&nbsp;I am totally stumped and have no idea how to fix this.&nbsp;If you need examples, please let me know.&nbsp;Any help would be great.&nbsp;Thanks,Chris

rajendraongole1 · Accepted Answer

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.

Forum Discussion

Creating Measures on data from a Sharepoint List

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Sharepoint list mirroring

Create count measure

Extract Data from sharepoint