RANKX with MAXX - KPI Information

felipereis50 — Wed, 26 Jul 2023 11:53:45 GMT

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?

Re: RANKX with MAXX - KPI Information

felipereis50 — Wed, 26 Jul 2023 12:06:58 GMT

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_)

topic Re: RANKX with MAXX - KPI Information in DAX Commands and Tips

RANKX with MAXX - KPI Information

Re: RANKX with MAXX - KPI Information