Forum Discussion

Kurumi0418's avatar
Kurumi0418
Helper I
8 years ago

I Have one important question.

  Hello everyone,   How to use value = table, question as blow :   Value: Overall Turn rate history = DIVIDE( SUM('WAITING_TIME_REPORT_HISTORY'[Rule Output]), SUM('WAITING_TIME_REPORT_HISTOR...
Need Help
Kurumi0418's avatar
Kurumi0418
Helper I
8 years ago

Hi Quentin,

 

I want "C_Table" = overall turn rate values, it doesn't percetage.

 

Thanks.

 

Because, I want use "C" to X bar, but now I just have overall turn rate value, and it doesn't same with "C"

 

Overall turn rate is right valure = Rule output/WIP

 

See the picture. thanks Quentin.

 

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Kurumi0418

 

I'm note to understand what you want but did you try this : 

 

CALCULATE(DIVIDE(sum('WAITING_TIME_REPORT_HISTORY'[Rule Output]),sum('WAITING_TIME_REPORT_HISTORY'[WIP]));ALL(WAITING_TIME_REPORT))

If this doesn't work can you tell me the values expected of C_Table ? (Is C-Table the yellow line on the picture ? )

 

- Quentin

  • Kurumi0418's avatar
    Kurumi0418
    Helper I
    8 years ago

    Hi Quentin,

     

    I want use measure value in Chart X bar like "1.3", But now I use Column calculate [Rule output/WIP] it's different "Overall turn rate" value, so how can I make right valure?????

     

    • Kurumi0418's avatar
      Kurumi0418
      Helper I
      8 years ago

      quentin_vigne

       

      Hi Quentin,

       

      I want use measure value in Chart X bar like "1.3", But now I use Column calculate [Rule output/WIP] it's different "Overall turn rate" value, so how can I make right valure????? 

      2018-06-14 18_10_19-ASE Test Version - Power BI Desktop.png

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Kurumi0418,

        I am not very clear about your expected result. Do you want to make Overall Turn rate history measure return same result as "C的平均" calculated column and “C的平均” column is calculated using DAX below ? If so, quentin_vigne's DAX should works.

        C的平均 = DIVIDE(sum('WAITING_TIME_REPORT_HISTORY'[Rule Output]),sum('WAITING_TIME_REPORT_HISTORY'[WIP]))



        If you still have questions about the DAX, please review this thread about how to share sample data and post expected result.

        Regards,
        Lydia