DAX count measure result

[marquespolastri]

Hi, I have a problem to calculate the count of values from Measure results.

The measure return the Status for each day.

LogStatus =
VAR CurrentDate = SELECTEDVALUE(AllDates[Date])
VAR MaxDate = CALCULATE(MAX('LOG'[DTH_INCLUI_LOG]);'LOG'[DTH_INCLUI_LOG] <= CurrentDate+1)
RETURN CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = MaxDate)

I need to calculate a count of each status by day. Is possible to do it?

[TomMartens]

Hey,

did you already to add another measure like so:

CountStatus =
VAR CurrentDate = SELECTEDVALUE(AllDates[Date])
RETURN
CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = currentDate)

And just add the column

'LOG'[VLR_NOVO]

either to the row or columns of your matrix visual.

Regards

Tom

[marquespolastri]

Tom thanks for your return.

I tried to do it, but it does not work, see the prints:

Detail First TableDetail Log TableDetail New TableDetail New Measure

[marquespolastri]

Hi, I need a help to solve a problem to create a DAX Count based in the result of another measure.

Table 1: 

I did a measure to return the Status by day::

LogStatus =
VAR CurrentDate = SELECTEDVALUE(AllDates[Date])
VAR MaxDate = CALCULATE(MAX('LOG'[DTH_INCLUI_LOG]);'LOG'[DTH_INCLUI_LOG] <= CurrentDate+1)
RETURN CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = MaxDate)

Table 2:

I need to calculate the number of occurrences of each LogStatus per day.

How can I do it?