topic Using the Count Function with a Measure in DAX Commands and Tips

Using the Count Function with a Measure

Anonymous — Mon, 07 Nov 2022 20:38:46 GMT

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!

Re: Using the Count Function with a Measure

Anonymous — Mon, 07 Nov 2022 22:06:02 GMT

Hello Anonymous

Please try

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

Re: Using the Count Function with a Measure

wdx223_Daniel — Tue, 08 Nov 2022 03:08:39 GMT

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"