Forum Discussion

MSAYED26's avatar
MSAYED26
Icon for Helper II rankHelper II
3 years ago
Solved

Dax

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...
"Need Help"
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

try 
Count score 60 to 75 = Calculate(Count(table[Name]), Filter(table, AND(table[revenue] >=60 , table[revenue] < 75)))

Count score 75 and above = Calculate(Count(table[Name]), Filter(table, table[revenue] >= 75))

Count score 60 and below = Calculate(Count(table[Name]), Filter(table, table[revenue] < 60))