How to capture el 2do value but high

[Syndicate_Admin]

I have a problem with an exercise that I am doing, in another post I read that you could capture the 2nd highest value by assigning a column of RANK to determine the range, so far so good, but at the time of wanting to capture it I leave empty, if someone could help me I would appreciate it very much,

[v-xinruzhu-msft]

Hi @Syndicate_Admin 

First you need to confirm which table you used for the [Rank] measure, then try to replace the "filter table" to the table in "filter"

 

e.g 

2st high = CALCULATE(SUM('Table (4)'[Medida]),FILTER(ALLSELECTED('Table (4)'),[Rank]=2))

Best Regards!

Yolo Zhu

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

[Syndicate_Admin]

Hello friend, thank you very much for the help below I will give you more details about the exercise I am doing, I will also attach all the data next to the main file so that it is easier for you to fix the error if you wish, the file is called PowerBi2004, as you can see I am working with a relationship of different tables that I will also attach them:

These relationships are made because the data have their respective encoding, that allows to put the name of OP_Nombre in the report and that the data of Candidatos_Votos are shown in a grouped way, both the sum and the percentage of it with their respective filters, now the problems come when working with the measures, At first no, as you can see if I want to obtain the decimar value of the percentage is simple, the complex thing comes when you want to work new measures of values of other measures, for example in this view in measure 2, it is observed that it does not yield the result that devería, but that is resolved in another measure as seen in the card

Likewise with regard to the view of the problem I work with the same measure, I do another one called Rank, but at the time of trying to do what you told me, you can not since it is not with a single table that is working, but of 2 and measures, and there I think the problem is born, I hope you have understood my explanation

Files attached to the following Drive link:

https://drive.google.com/file/d/1LSwz1Yf-hotRt1yP2aSwaLhPpOEz4HeD/view?usp=share_link