Using Microsoft Form streaming Data

[abehrmann]

I am streaming data from a microsoft form for realtime results of a quiz using microsoft flow. 

I have the streaming data set up and have connected it to a report i am building on desktop. 

My problem is calculating scores. 

I am not able to do calculated columns to get the resluts; only measures. 

Is there a way i can use an if statement in a measure to give me a 1 or 0 if an aswer is correct.  

Then another measure that  sums all the correct answers for a total score. 

Table name: RealTimeData

Example Column: How many BTUs are in a ton?

Thanks for the help!! 

[v-chuncz-msft · Accepted solution]

@abehrmann,

Just specify an aggregation such as max to get a single result, and refer to this post to get total score.

IF ( MAX (