Forum Discussion
PaulHallam
Helper III
Helper IIICan i count values within a measure?
Hi I am new to the forum so apologise if this is a little garbled. Basically I need to know the count of values in different ranges within a measure….i think. I have a data table as below and have ...
Hi PaulHallam ,
Please create a table with decimal value of range start and end, then you can use following measure to summarize and look correspond records and get count of them.
Measure formula:
Summary Count = VAR temp = SUMMARIZE ( 'Sample', [Sensor Number], "Count", [Occupied Days], "Percent", [Occupied %] ) RETURN COUNTROWS ( FILTER ( temp, [Percent] >= MAX ( T4[Start] ) && [Percent] <= MAX ( T4[End] ) ) ) + 0Regards,
Xiaoxin Sheng
PaulHallamHelper III
Helper IIIHi v-shex-msft
Thank you for your help before, i need to so something similar and am applying the same logic as you have given for the previous solution.
I need to produce a graph as below showing the number of occurances of each count of occupied. From the previous data the graph would be
The number of occurances will differ massively so i cant just add a table as before and the graph needs to be updated by slicers.
Thanks in advance, P
PaulHallamHelper III
Helper IIIThe axis are the other way round. My mistake