Overlap

OK, I tried all different kinds of solutions to this and finally decided to just nuke it from orbit. Just to be sure... So basically, the task was that given a set of overlapping meetings, find the t...

overlap.pbix364 KB

Other

Time Intelligence

Totals

Euto

Frequent Visitor

5 years ago

Greg_Deckler Wow, this for sure a variation of a problem I am trying to solve.

I have some observation and questions based on this, that may help me solve my problem.

Here are my Observations

- I see that when I select a particular meeting, the Overlap Card visual give me either 1.00 or 0.50 which is good. And by clicking each indivual meeting I was able to get the following result for each index

1 - 1.00
2 - 0.05
3 - 0.05
4 - 0.05
5 - 1.00
6 - 1.00
7 - 1.00
8 - 1.00

- I also noticed that when no meeting is selected, the Overlap Card returns 3.00

Here are my Questions

1. How do I get the Overlap Card to return the Sum of the Overlap result (5.15) when their's no filter?

2. How do I get the result to sum up correctectly when a few meetings a selected?

Thanks in advance.

Greg_Deckler

Community Champion

5 years ago

Euto Ah, that is a measures total problem. The goal for Overlap was to get the total amount of time actuall spent in meetings that had overlapping times. So, the total amount of time overall is 3 hours. If you want the table to total to the individual values in the rows, you need the following:

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907