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 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?

 

Need Help

3 Replies

  • 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?