calculate measure to summarise count per day

[hugus]

Hi

this should be simple....cannot understand why it isnt.

i want to produce a bar chart, x axis is day of month, y-axis is total count of events over the day.

if the total count is above a set target, i want the bar green. if below, red.

I thought i could create a measure to say sum the total count over the day - but for some reason it does not let me do this....i woiuld then do: green column= if(count>target, count,0) and red column = if(count<target,count,0)

i cant even select the [count] column when i try create a measure....so i tried creating a column instead and gives me incorrect data.

why cant i select [count] when i create a measure?? help please - going insane!!

[v-frfei-msft]

Hi @hugus ,

Does constant line meet your requirement?

[hugus]

hi @v-frfei-msft 

no this doesnt do it....the line will need to be different for each day as the target is changing....

[v-frfei-msft]

Hi @hugus ,

Where the target comes from? Does using a What if parameter work in your scenario?