So this is filtered on the specific key so the solution should also work when the filter is off.
I have deliveries and on these deliveries there are material. But also a Log Month.
What I want it to only count the quantity once.
Thought I already had that covered with looking at the max log month and only put the quantity there
But as appeared a delivery could also be be done double for only a few materials.
Therefore I had to go a level deeper on material.
I made a key combining delivery and material.
So in this example the key occurrs twice so the ‘CountMat’ should give 2 and not 1
When there is only 1 log month for a key it should give 1.
Tried several count option, for not this one is :
=Count([Variables].[Key]) ForAll ([Variables].[Delivery])
But this thing keeps giving me headaches…because of course I want to hide these zeros.
In the formatting of the block it will not work. Guess because MthChk also needed to be a measure field for some reason.
But putting a filter on Mthck hides the lines with “Hide” but is screw up the total!
First of the Amount comes from a 2nd query and the other fields form 1st query.
These queries have been merged like this:
The key is not very special on both queries it is delivery+material
