CODEWITHSUNDEEP
filtermaxtableau-api
L.Rencoret
L.Rencoret

Reputation: 155

Tableau - Filter Dimension on Max Value of Measure

I'm trying to calculate the MAX value of column D of value E which resets for every A Column. Later I just need to show the MAX row of A.

Raw data looks like this: enter image description here

The desired view would be like this: enter image description here

Thanks!

Upvotes: 3

Views: 3273

Answers (1)

MonteCarloSims
MonteCarloSims

Reputation: 1771

This is an excellent example of a question which can/should be answered using LOD Calculations.

To start, find the maximum [Percentage] (Column E) per [Name] (Column B):

{Fixed [Name]: MAX(Percentage)}

Then insert that calculation, call it "Max Per Name", into another calculation which will only show the [Letter] (Column D) if the [Percentage] and the [Max Per Name] match: 

IF [Percentage] = [Max Per Name] THEN [Letter] END

The result will be a dimension which shows the [Letter] which matches the largest [Percentage] and 'Null' when not matched.

From here, just filter out 'Null' - the result will be exactly as you desire. You will even be able to take [Percentage] off the view and still see an accurate [Letter].

Please note that while LOD Calculations are extremely powerful, they require a little more work to maintain and operate. They are a little more complex than normal calculations. Please take some time and read through this LOD Overview document to further familiarize yourself with their use/limitations.

Upvotes: 1

Related Questions