Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure for count

Hi I need a measure that will count. The column is sorted by colors (orange, yellow, blue, green). I need a measure that will count and add up all the blue and green and divide by the total number o...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Try this meausre

    Measure = var _blue=CALCULATE(COUNT('Table'[Color]),FILTER(ALL('Table'),[Color]="Blue"))
var _green=CALCULATE(COUNT('Table'[Color]),FILTER(ALL('Table'),[Color]="Green"))
var _total=CALCULATE(COUNT('Table'[Color]),ALL('Table'))
return DIVIDE(_blue+_green,_total)

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

speedramps's avatar
speedramps
Super User
4 years ago

Hi bossyr94

 

YourAnswer =

VAR colurcount =  COUNT(Table[colour]) =  COUNT(Table[color])

VAR allcolourcount =  CALCULATE(COUNT(Table[color]),ALL())
RETURN
DIVIDE(colurcount, allcolourcount )

Create table visual with

Colour, count of colur and [YourAnswer]

 

Please click thumbs up and Accept as Solution. Thak you ðŸ˜€