8 Replies Latest reply on Jan 27, 2017 10:40 AM by Priscilla Oliveira

Using the same formula as a counter and filter, I'm getting different results....

sum({ FIXED [RevendaConhecida Revenda], [Cultura Principal],[Tradicao]: sum(IIF([Entrevista Distribuidor]=[Parâmetro Entrevista Distribuidor],1,0))})

The visible difference of the value added with the filter is that the value of the graph is composed of nulls.

To try to get around this, I added the "exclude" to not consider this column, but it still did not work.

A possible solution would be to use a rank_unique with the result of that formula, but it is not possible because it disrupts the graph...

I have no idea how to solve this, but I need to get only the first 10 considering that formula.

Can someone help me?

• ###### 1. Re: Same formula as a counter and filter AND getting different results. Please help-me!

Hi Priscilla, have you tried making your filters into context filters?

• ###### 2. Re: Same formula as a counter and filter AND getting different results. Please help-me!

You can also try this: change the filters back to normal filters, then sort your rows in descending order (so that the top rows are at the top). Then, add this as a filter:

INDEX() <= 10

This is a table calculation, so make it compute along Table (Down). Keep only TRUE. Does that give you what you want?

• ###### 3. Re: Same formula as a counter and filter AND getting different results. Please help-me!

I tested it now but it did not work.. =/

• ###### 4. Re: Same formula as a counter and filter AND getting different results. Please help-me!

not work....

• ###### 5. Re: Same formula as a counter and filter AND getting different results. Please help-me!

Can you share a packaged workbook (with any non-file data sources extracted) so I can try? It's hard to figure out without the underlying data.

• ###### 6. Re: Same formula as a counter and filter AND getting different results. Please help-me!

Sorry for the delay. But if you can still try to help me ...

Sorry for the amount of unnecessary and unnamed calculations... I was trying various possibilities for several small problems I had while doing this dashboard...

• ###### 7. Re: Same formula as a counter and filter AND getting different results. Please help-me!

Is this what you're looking for?

The main thing I did was remove the SUM() around the LOD calculation in Calculo3. That allows you to use it as a dimension.

Solution attached (Tableau 10.1+).

• ###### 8. Re: Same formula as a counter and filter AND getting different results. Please help-me!

In that solution ... appeared the line that I need ... but, instead of listing the TOP10 ... he made a TOP11 ...

Besides that....If you change the filter "Cultura Principal" mess the graph ...

And if the filters are not in context, they also mess up..