RETURN HIGHEST LIST FROM THIS TABLE PER MONTH

[Adeblezen]

Good day here.

Please I need assistance on this.

I want to use a Card Visual to return the Asset with highest, filter by month.

Eg, in Jan FVLG 3 has the highest cost. Thanks

LINEMONTH COST 

FVLG 1	JAN	$ 12,033.00
FVLG 2	JAN	$ 14,000.00
FVLG 3	JAN	$ 23,100.00
FVLG 1	FEB	$ 25,000.00
FVLG 2	FEB	$ 12,004.00
FVLG 3	FEB	$ 23,130.00
FVLG 1	MAR	$ 22,000.00
FVLG 2	MAR	$ 14,022.00
FVLG 3	MAR	$ 30,034.00

[v-zhangti]

Hi, @Adeblezen 

You can try the following methods.

Measure = CALCULATE(MAX('Table'[COST]),ALLEXCEPT('Table','Table'[LINE],'Table'[MONTH]))

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Adeblezen]

Thanks...Great but i will like to have the Line and not the Cost on the Card

[v-zhangti · Accepted solution]

Hi, @Adeblezen 

You can try the following methods.

Max Cost = CALCULATE(MAX('Table'[COST]),ALLEXCEPT('Table','Table'[LINE],'Table'[MONTH]))

Measure = CALCULATE(MAX('Table'[LINE]),FILTER(ALLEXCEPT('Table','Table'[MONTH],'Table'[LINE]),[COST]=[Max Cost]))

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Adeblezen 

Are you going to have one card for each month?

[Adeblezen]

No....The month will be a Filter...The highest Line will be display on the Card