Forum Discussion

Baarathi88's avatar
Baarathi88
Icon for Helper III rankHelper III
6 years ago

Dynamic Top Value of column based on Measure

I'm trying to add 2 measure values in Line Chart, both measure values have to show sales. But Measure1 should show value of the Company which has done most sales over a period of time and Measure2 sh...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Baarathi88

For 2020, did you mean 120 for measure1, 90 for measure2. (The max is 120, second high sales is 90).

In this case, you do not need the rank measure, two simple measures should do. 

 

Measure 1 = MAX('Table'[Sales])
Measure 2 = CALCULATE(MAX('Table'[Sales]),FILTER('Table',[Sales]<MAX([Sales])))

 

 


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Baarathi88's avatar
Baarathi88
Icon for Helper III rankHelper III
6 years ago

Anonymous I'm Sorry, Actually this is not the actual solution, In the image that has been shared by you the value 120 is coming in dark blue line, as per my scenario, it should come under light blue line.

 

Light blue line should have maximum value - maximum value for 2019 is 900 and maximum value for 2020 in 120

 

According to your logic it is taking summation and determining the maximum which is not the right approach.