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
PBI User Groups

Welcome to the User Group Public Preview

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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

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.