Forum Discussion
FelipMark
Helper II
Helper IIUse count with measure
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( ...
tamerj1
Community Champion
Community ChampionHi 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] )
)