cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kurumi0418 Regular Visitor
Regular Visitor

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_HISTORY'[WIP])
)

 

Table:

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

 

BUT..............result is diff. so I want to know how could I set up in this question????

 

2018-06-14 13_54_45-ASE Test Version - Power BI Desktop.png

8 REPLIES 8
quentin_vigne Senior Member
Senior Member

Re: I Have one important question.

Hi @Kurumi0418

 

What result are you expecting ? Show us what the column C should look like (with value)

You need a percentage ? 

 

- Quentin

Kurumi0418 Regular Visitor
Regular Visitor

Re: I Have one important question.

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.

 

1112018-06-14 17_50_49-ASE Test Version - Power BI Desktop.png

quentin_vigne Senior Member
Senior Member

Re: I Have one important question.

@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 Regular Visitor
Regular Visitor

Re: I Have one important question.

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

Kurumi0418 Regular Visitor
Regular Visitor

Re: I Have one important question.

@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

Moderator v-yuezhe-msft
Moderator

Re: I Have one important question.

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Kurumi0418 Regular Visitor
Regular Visitor

Re: I Have one important question.

@v-yuezhe-msft

 

My real question is :

 

Same rule, why value is different????

 

Overall turn rate is use measure

Table turn rate is use column

 

I just want to know how can I get same data value?????????

 

2018-06-15 17_10_02-IE Waiting Time Report_Develop_Version - Power BI Desktop.png

Highlighted
Moderator v-yuezhe-msft
Moderator

Re: I Have one important question.

@Kurumi0418,

Please use quentin_vigne's DAX to create Table turn rate column, if you still get wrong result, please share sample data as my previous post.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.