Altering Distint Count through Drill

[matthewjbryant]

I have a table of deliveries where each delivery can have multiple parts on it. I want to create a drill through company to part that counts the deliveries as distinct relative to the dimension. Deliveries are not split at a company level, but are at a part level.

I have produced a QVW of what I want to see, but it is hard coded with if(GetCurrentField(), which is not ideal because in my live document I use a dynamic drill the user can change the dimensions should they wish.

Is there a better way?

[lironbaram]

hi

may be i am missing something

but why not use a simple

count(distinct Delivery)

[matthewjbryant]

Thanks for the response Liron. I've amended the Drill table to show why. I need the Delivery Count column to be replicated, but I can't get this with a simple Count(Distinct()). On the company level one field is correct, but on the part level the other is correct.

[lironbaram]

hi Matthew

i think the correct total from business perspective should be 2 even

when you look at part as dimension because you really have only 2 deliveries and not 5

i didn't manage to see a problem in the new model, what were you refering to?