Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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????
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.
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?????
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,
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
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?????????
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |