topic Re: dax measure show the highest value in a period in DAX Commands and Tips

dax measure show the highest value in a period

Anonymous — Thu, 04 Feb 2021 15:27:44 GMT

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.

Re: dax measure show the highest value in a period

amitchandak — Thu, 04 Feb 2021 17:03:28 GMT

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

Re: dax measure show the highest value in a period

Anonymous — Thu, 04 Feb 2021 19:50:56 GMT

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.

Re: dax measure show the highest value in a period

Anonymous — Fri, 05 Feb 2021 12:08:16 GMT

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.

Re: dax measure show the highest value in a period

amitchandak — Fri, 05 Feb 2021 13:31:10 GMT

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

Re: dax measure show the highest value in a period

Anonymous — Fri, 05 Feb 2021 14:26:30 GMT

Same.

Re: dax measure show the highest value in a period

Anonymous — Wed, 17 Feb 2021 19:38:54 GMT

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.