cancel
Showing results for
Did you mean:
Frequent Visitor

## DAX count measure result

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?

3 REPLIES 3
Super User II

Hey,

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

'LOG'[VLR_NOVO]

either to the row or columns of your matrix visual.

Regards

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Frequent Visitor

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

Detail First TableDetail Log TableDetail New TableDetail New Measure

Frequent Visitor

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?

Announcements