cancel
Showing results for
Search instead 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,

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

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

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

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?

## Helpful resources

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

#### Check it Out!

Click here to read more about the April 2021 Updates!

#### The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors