topic Re: Use count with measure in DAX Commands and Tips

Use count with measure

FelipMark — Wed, 03 May 2023 18:30:47 GMT

Hi guys, I have a doubt about something that I believe is simple.

I created a conditional measure in DAX to understand if the product passed the reorder point or not.


# Status Stock = SWITCH(
 TRUE(),
 SUM(fStock[STOCK]) >= [Order Point], "Ok",
 SUM(fStock[STOCK]) >= [Order Point] * 0.8, "Attention",
 "Request Product")

I would like to create a chart that contains the count of each of the 3 statuses. But when trying to use the Count function, it is not allowed to include measures, only columns.

Re: Use count with measure

milanpasschier3 — Wed, 03 May 2023 18:38:38 GMT

Hey, can you create a calculated column of this measure so that you can use it as a column for the chart?

Re: Use count with measure

tamerj1 — Wed, 03 May 2023 19:02:51 GMT

Hi FelipMark

Manually create a single column table 'Statuses' that contains the 3 statuses. Then you can place 'Statuses'[Status] in the x-axis and the following measure in the values.
Count =
SUMX (
CROSSJOIN ( VALUES ( 'Statuses'[Status] ), VALUES ( fStock[Material ID] ) ),
INT ( 'Statuses'[Status] = [Status Stock] )
)