dax measure show the highest value in a period

[Anonymous]

Hi guys,

Im trying to show only the month's max value along the period, but it isn't work it.

I have try a lot of option... I confess... I'm frustate. Here is the last formula.

MAXX Distinctcount Unique Contract = maxx(allselected(d_NTT_Dinamic_DataTable[Month Name]),DISTINCTCOUNTNOBLANK('BaseContratosMensais_IndicadorGerencial - SQL Results'[#UNIQUE_CONTRACT]))

Tks,

---

Alexandre.

[Anonymous]

It changed a little bit, but it not what I'm looking for.

Top 1 Rank = CALCULATE([Distinctcount Unique Contracts],TOPN(1,ALL(d_NTT_Dinamic_DataTable[Month Name]),[Distinctcount Unique Contracts],DESC),VALUES(d_NTT_Dinamic_DataTable[Month Name]))

Tks,

---

Alexandre.

[amitchandak]

@Anonymous , Try TOPN on month

Top 1 Rank = CALCULATE([Distinctcount Unique Contract],TOPN(1,all(Table[Month Year]),[Distinctcount Unique Contract],DESC),VALUES(Table[Month Year]))

[Anonymous]

It changed a little bit, but it not what I'm looking for.

Top 1 Rank = CALCULATE([Distinctcount Unique Contracts],TOPN(1,ALL(d_NTT_Dinamic_DataTable[Month Name]),[Distinctcount Unique Contracts],DESC),VALUES(d_NTT_Dinamic_DataTable[Month Name]))

I'm looking for this.

Tks,
Alexandre.

[amitchandak]

@Anonymous , remove the other measure from the table and check.

[Anonymous]

Same.

[Anonymous · Accepted solution]

I have found a solution.

Top 1 Rank = CALCULATE([Distinctcount Unique Contracts],CALCULATETABLE(TOPN(1,ALL(d_NTT_Dinamic_DataTable[Month Name]),[Distinctcount Unique Contracts],DESC),ALL(d_NTT_Dinamic_DataTable),VALUES(d_NTT_Dinamic_DataTable[FY_NTT])))

After that, I have made a chart to highlight the major value.

Many thanks everybody.