1 of 1 people found this helpful
Is there a requirement that you have to keep each metric on a separate worksheet and compile them together on the dashboard - or would it be ok to place them all on the same worksheet?
Your issue right now is that for PDA Zero right now, Tableau doesn't know that the values for LAP, SCOM, etc are null because they don't exist for that measure, even though it exists for your other measures, since you've filtered the one worksheet to that specific measure, it doesn't know that LAP and SCOM values should exist anymore than it would know to include apples and oranges.
If you place all of your measure on a single worksheet, then Tableau will see that for given measures, certain row values are null, and then I believe you calculation will work.
Thank you for the input Paul. I originally didn't want to try and add all the measures to the same sheet as it would've required an significant headache in attempting to get all of my calculations to work under the same filters... but I got done what needed to get done. It isn't super pretty, but it looks good. Thanks for steering me in the right direction.