Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a large table that is similar to the one below. My desired visual will have the difference between the best and worst driller's connections times on each rig. I've attempted to use the Summarize function and creating new tables and relationships in my data model, but I can't seem to put it together to get what I'm looking for.
Desired Visual will be a table that will look like this, but with the final number instead of the equation, but I put the equation in to hopefully be more clear about what I'm trying to make happen.
Also, would it be any different if the initial table in this was already summarized from another table?
Thanks!
Solved! Go to Solution.
My approach would be to keep the table you have in your post, and create some measures. I played around with your table and created these measures (I called the table DrillTime):
Best Time = MIN ( DrillTime[Connection Time] ) Worst Time = MAX ( DrillTime[Connection Time] ) Time from Best = [Worst Time] - [Best Time] Worst Driller = CONCATENATEX ( TOPN ( 1, VALUES ( DrillTime[Driller] ), CALCULATE ( AVERAGE ( DrillTime[Connection Time] ) ), DESC ), DrillTime[Driller], ", ", DrillTime[Driller] )
If I put these in a table with Rig I get:
Note that Worst Driller concatenates ties.
Are you able to get these working? I can post a link to my model later today if useful.
Regards,
Owen 🙂
Thanks, I wound up using your expression to get the names!
My approach would be to keep the table you have in your post, and create some measures. I played around with your table and created these measures (I called the table DrillTime):
Best Time = MIN ( DrillTime[Connection Time] ) Worst Time = MAX ( DrillTime[Connection Time] ) Time from Best = [Worst Time] - [Best Time] Worst Driller = CONCATENATEX ( TOPN ( 1, VALUES ( DrillTime[Driller] ), CALCULATE ( AVERAGE ( DrillTime[Connection Time] ) ), DESC ), DrillTime[Driller], ", ", DrillTime[Driller] )
If I put these in a table with Rig I get:
Note that Worst Driller concatenates ties.
Are you able to get these working? I can post a link to my model later today if useful.
Regards,
Owen 🙂
Thanks! I've got my table up and running!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
74 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
85 | |
64 | |
59 | |
56 |