Using Count with a Measure

[Anonymous]

Hi! 

I am looking to "count" how many customer's are considered  to have "Increasing" sales and how many are considered to be "Decreasing".  I would like to add the result to a Card visualization.  

Here is my measure:

I'm confused on how to combine "count" with a measure (or if I need to go about finding the answer in a different way).

Thanks for the help!

[Greg_Deckler]

@Anonymous This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

[Anonymous]

Unfortunately, I don't believe this is what I am looking for.

[Greg_Deckler · Accepted solution]

@Anonymous You can't do something like:

Count of Increasing = 
  COUNTROWS(
    FILTER(
      SUMMARIZE('Customers',[Customer],"__Measure",[Increasing or Decreasing]),
      [__Measure] = "Increasing"
    )
  )

[Anonymous]

@Greg_Deckler  Wonderful, it worked! Thank you!!!