Forum Discussion
Solved
Measure count
Hi, i have created the following measure, which is working properly in the below table for each row, except of the grand total: fyi, if there is a cross in a row, the last column (check measure) s...
Hi technologyLMM
There are some workarounds to fix totals, please refer linked tutorial of @Greg_Deckler:https://www.youtube.com/watch?v=dgwsk2fjWLc
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I think your processing result (=9) is correct. You calculate a count of vessels.
You have 9 rows above your Total line. Your result = 9.
Behind the scenes the "Total" line consists of 9 rows (in your case). These 9 rows contain cross (red) and checks (green). Both categories. How to decide for DAX when both cases are present?
For DAX there no explicit filter context for "Total" like in each row above.
But I know what you mean!
It is bit confusing.