Using the Count Function 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!

[wdx223_Daniel · Accepted solution]

NewMeasure=VAR _tbl=ADDCOLUMNS(VALUES(TableName[CustomerID]),"@Status",[Increasing or Decreasing]) RETURN COUNTROWS(FILTER(_tbl,[@Status]="Increasing")) & " Customers Increasing and "&COUNTROWS(FILTER(_tbl,[@Status]="Decreasing"))&" Customers Decreasing"

[Anonymous]

Hello @Anonymous 

Please try

Calculate(countx(table,[the measure]),[the measure] = "Decreasing")