cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marquespolastri
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?

 

Chamado_Status.JPG

3 REPLIES 3
TomMartens
Super User II
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

Tom thanks for your return.

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

 

Detail First TableDetail First TableDetail Log TableDetail Log TableDetail New TableDetail New TableDetail New MeasureDetail New Measure

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?

 

Chamado_Status2.JPG

Helpful resources

Announcements
User Groups Public Preview

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.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

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.