Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

YTD Average - DAX calculation

Dear all, I'm trying to calculate the YTD Average value - but I would need your help on this KPI & DAX language. Data are like this: -> Conformity level (Grade A = OK/NON OK per scan/factory/etc.)...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    pls try this

    Measure = DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[CONFORMITY]="OK")),COUNTROWS('Table'))

  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    pls change year to rclms_qa[year]

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Strange - yes, my column name is "year"

 

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Anonymous 

pls change year to rclms_qa[year]

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks a lot for your help - it works

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    And I have another question to complexify a bit.

    Can you the created formula:

     

    YTD 2021 = Divide(CALCULATE(COUNTROWS(rclms_qa), FILTER(rclms_qa,rclms_qa[CONFORMITY]="OK"&&rclms_qa[Mars Year]=2021)),CALCULATE(COUNTROWS(rclms_qa), FILTER(rclms_qa,rclms_qa[Mars Year]=2021)))*100
     
    And add some DAX elements to get the results of my last 13 periods?
    Thanks
    Hervé