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 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)

 

 

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.

2 Replies

  • 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 ğŸ˜€

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.