If I produce a table with this dimenion and a meassure ("Value_1") with this ex above, I'll get 2 values:
I am confused because for the dimension "none" I am counting 5, not 4 as it was calculated by the ex. I tried to count other fields, ie agency or ID_6 but the output for "Value_1" was the same every try.
Unfortunatelly I cannot manipulate the given rawdata, to avoid dublicates, because dublicates should also be kind of the counted value.
Where is my fault? I hope you guys can stick my nose of the root cause.
I'll thank you very much for your help.
P.S. Please excuse me, I hope my english is understandable
Re: Need help for set analysis with three parameters
I have to thank you for your time for taking care of my little problem - I have to apologize also because the given details were not as accurate as they should be. There are much more datasets and different possibilities of two or more ID_98-dublicates.
Nevertheless - I've found my fault: at first step I had the oppinion that I could count ID_98 and it would be nice. But the described value was the "reaction". Now I am doing this: