Forum Discussion
MSAYED26
Helper II
Helper IIDax
Hello All I try to count how many with average score in one month in each range (>=75)&(>=60&<75) & (,60) ,in this example in one month i have count 2 in range (>=60&<75) and 1 in range (>=75) , al...
Hi MSAYED26 ,
Please try:
Range1 = var _a = SUMMARIZE('Table','Table'[Name],"Average",AVERAGE('Table'[Score])) return COUNTROWS(FILTER(_a,[Average]>=75)) Range2 = var _a = SUMMARIZE('Table','Table'[Name],"Average",AVERAGE('Table'[Score])) return COUNTROWS(FILTER(_a,[Average]>=60&&[Average]<75)) Range3 = var _a = SUMMARIZE('Table','Table'[Name],"Average",AVERAGE('Table'[Score])) return COUNTROWS(FILTER(_a,[Average]<60))Then you can create a slicer with [Date], the output will change with the slicer:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jianboli-msft
Community Support
Community SupportHi MSAYED26 ,
Please try:
Range1 =
var _a = SUMMARIZE('Table','Table'[Name],"Average",AVERAGE('Table'[Score]))
return COUNTROWS(FILTER(_a,[Average]>=75))
Range2 =
var _a = SUMMARIZE('Table','Table'[Name],"Average",AVERAGE('Table'[Score]))
return COUNTROWS(FILTER(_a,[Average]>=60&&[Average]<75))
Range3 =
var _a = SUMMARIZE('Table','Table'[Name],"Average",AVERAGE('Table'[Score]))
return COUNTROWS(FILTER(_a,[Average]<60))Then you can create a slicer with [Date], the output will change with the slicer:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.