Forum Discussion

marquespolastri's avatar
marquespolastri
Frequent Visitor
8 years ago

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 MaxDa...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

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

marquespolastri's avatar
marquespolastri
Frequent Visitor
8 years ago

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

  • marquespolastri's avatar
    marquespolastri
    Frequent Visitor
    8 years ago

    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?