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 Table Detail Log Table Detail New Table Detail 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 #### Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview. #### 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. Top Solution Authors
Top Kudoed Authors
Users online (2,938)