Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kurumi0418
Helper I
Helper I

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
Solution Sage
Solution Sage

Hi @Kurumi0418

 

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

You need a percentage ? 

 

- Quentin

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

@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

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

@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

@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.

@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

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.