One field with value from multiple measures that can be filtered by multiple filters

0 votes
I have the following calculated field:

{FIXED starttime, zone:
 max(if zone = zone b then 'calculated field  zone b'
elseif zone = zone c then 'calculated field zone c'
End)}

This calculated field allows me to filter on a specific or multiple zones and then shows the total for the selected zones that have a relationship with the calculated field as the if statement shows.

Now I have the same calculated field, but then for department:

{FIXED starttime, department:
 max(if department = department A then 'calculated field department A'
elseif department = department B then 'calculated field department B'
End)}

As you can imagine, both calculations are working with a different filter (dimension); department and zone.

But now I want to have 1 calculated field which contains the result of both calculations from above. So that when I filter on zone B and department A, I get the sum of the filtered dimension based on of course the underlying calculations which I talked about before.
This allows me to have one field to use in a sheet in stead of two.

How can this be achieved?

Thanks
Mar 16, 2023 in Tableau by anonymous

edited Mar 5, 2025 607 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP