RANKX with MAXX - KPI Information

[felipereis50]

Hi friends
I would like some help.
I have a fTable with some product revenue values, return values, transfer...etc and I made a rankx to show de best selling product.

(using top N)

And I'm using an external filter on table
Read "1-Faturamento Saídas" like Revenue

--------------------off topic------------
If I don't use external filter the values will be for all table, and I need only revenue

RankX_Vendas =

VAR vRank = RANKX(ALL(fDados[DESCRICAO (#1)]),[TopN_Vendas_v6],,DESC)

RETURN

IF(

    vRank <= 'TopN(Parameter)'[TopNvalor] && ISINSCOPE(fDados[DESCRICAO (#1)]),

    vRank ,

    BLANK())

TopN_Vendas_v7 =

CALCULATE(

        [#vlr_contabil],

            KEEPFILTERS(TOPN('TopN(Parameter)'[TopNvalor],ALL(fDados[DESCRICAO (#1)]),[#vlr_contabil])))

Now, I want to show in another column with the MAXx, the  value for the first item  and so on, until TOPN
Then I created another measure
In this measure I'm forcing the filter inside the formula intead external filter.

MAXX_teste =

MAXX(fDados,

CALCULATE(

        [#vlr_unit_item],

            FILTER(dCFOPeFaturamento,dCFOPeFaturamento[EVOLUÇÃO TRIBUTOS CFOP] = "1 - Faturamento Saídas"))

      )

The result is values is corretc, but, when a put the measure on the table, the Dax expand for all products

-----------check value - rank number 1 --------------

What I have to do to not expand the table? 

[felipereis50 · Accepted solution]

Myself find a way. I Have use an IF on formula.

MAXX_teste =

var ma_ = MAXX(fDados,

        CALCULATE(

                [#vlr_unit_item],

                    FILTER(dCFOPeFaturamento,dCFOPeFaturamento[EVOLUÇÃO TRIBUTOS CFOP] = "1 - Faturamento Saídas"))

                    )

RETURN

IF([TopN_Vendas_v7] = BLANK(), BLANK(), ma_)