Forum Discussion
Measure to Total different rows and columns
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 ...
Good afternoon,
One more thing to mention. I kind of fixed it myself. But the totals are not working correctly.
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.
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.
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.
Thank you in advance.
George
- v-janeyg-msft
Community Support
Hi, geivaz0606
I checked your code and there is no problem, and the total is displayed normally.
Can you provide a sample file? What should be the correct value of total? We need specific data to analyze.
Janey
