Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

MAA - Calculation

Hello to all,

Can I use this 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 get the results (adding a DAX formula) of the last 13 periods (from today until the last 13 periods).
Thanks
Hervé
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Anonymous ,

    I created some data:

    Here are the steps you can follow：

    1. Create calculated column.

    Period number = VALUE(RIGHT([Period],2))

    2. Create measure.

    Measure =
var _OK=COUNTX(FILTER(ALL('Table'),[Year]=2021&&[CONFORMITY]="OK"&&[Period number]<=13),[CONFORMITY])
var _total=cOUNTX(FILTER(ALL('Table'),[Year]=2021&&[Period number]<=13),[CONFORMITY])
return
DIVIDE(_OK,_total)

    3. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    Can you share some sample data with the desired output to have a clear understanding of your question? Mention whether you want a calculated column or measure
    You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello

      Here is an example of data:

      YearCONFORMITYPeriodFactories
      2020OKP13RCA
      2020OKP13RCA
      2020OKP13RCA
      2021OKP01RFT
      2021WRNG_NOKP01RFT
      2021OKP02RNI
      2021OKP02RNI
      2021OKP02RNI
      2021OKP02RNI
      2021OKP02RNI

       

      Outcome is % of OK product vs the total (OK/NON OK or Warning) over the last 13 periods.

      Hope it helps,

      Hervé

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Anonymous ,

    I created some data:

    Here are the steps you can follow：

    1. Create calculated column.

    Period number = VALUE(RIGHT([Period],2))

    2. Create measure.

    Measure =
var _OK=COUNTX(FILTER(ALL('Table'),[Year]=2021&&[CONFORMITY]="OK"&&[Period number]<=13),[CONFORMITY])
var _total=cOUNTX(FILTER(ALL('Table'),[Year]=2021&&[Period number]<=13),[CONFORMITY])
return
DIVIDE(_OK,_total)

    3. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.