Measure for count

[Anonymous]

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 of all colors blue,green,yellow, orange. Idea of what I need below:

I need a measure that adds the 5 blue+7 green / 15 (all the colors included)

[Anonymous · Accepted solution]

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]

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 😀