Measure to Total different rows and columns

Question

I have what seems like a very simple issues.

The Dataset looks like this. As you can see, it is multiple test numbers with corresponding check numbers. I am only showing 1 specific test, but there are obviously many thousands of test with many thousand check numbers. What happens i that user will search for a particular "Check Number" and what they need is the Requested Time that "Test No". So for example, is this case if one were to search for "1968291C1" in the Check number, they would would get 30.2. My problem is that because the check number and the Requested time, are not on the same line, when someone does a filter (search) for that check number, what they get is "0.0". How do I solve this issue?

Thank you in advance.

George

geivaz0606 · Answer

Good afternoon,One more thing to mention.&nbsp; I kind of fixed it myself.&nbsp; But the totals are not working correctly.&nbsp;I added a following measure.Requested Time Fixed Kind of = CALCULATE(SUM('Fact Claims'[Requested Time]),ALL('Fact Claims'[Check Number]))This measure basically ignores the filter for Check Number Which means that we get all of the Requested Time SUMMED up which give me what I am looking for.&nbsp;The problem now is. when I remove the filter for "Test No" because normally I would want to see all of the "Test No" with this particular "Check Number", I get a total that id not correct.&nbsp;&nbsp;Thank you in advance.George