Get the First Value in My Table and Get It in a Measure

[Syndicate_Admin]

Please your support I am trying to get the value of the first day in this table you only have 15 days always and you want to obtain in a measure the value always of the first I realize it as follows:

ValMin = CALCULATE(SUMX(ALLSELECTED(Quiebre_8S[Date]),[Prom Valued L2W]),Quiebre_8S[Ranking]=1)

Thank you very much in advance.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

My Sample:

 

Try this code to achieve your goal.

ValMin =
CALCULATE (
    SUM ( Quiebre_8S[Prom Valued L2W] ),
    FILTER ( ALLEXCEPT ( Quiebre_8S, Quiebre_8S[Type] ), Quiebre_8S[Ranking] = 1 )
)

Result is as below.

Best Regards,
Rico Zhou

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

[AllisonKennedy]

@Tux-CM It looks like you have what you describe. Can you please explain further what is not working so we can help?

[Syndicate_Admin]

hello @Syndicate_Admin the value of 12,727,467 should go out in the entire VALMIN column but if you realize it only comes out for the first 3, do you know why that is happening?

[Tux-CM]

Hi @AllisonKennedy , the value of 12,727,467 should appear in the entire VALMIN column but if you realize it only appears for the first 3, do you know why that is happening?

Thanks in advance.

[Ashish_Mathur]

Hi,

Does this measure work?

Measure = MINX(ALL(Calendar[Fecha]),[Prom Valued L2W])

If it does not, then share the download link of your PBI file.

[AllisonKennedy]

@Tux-CM Sorry I didn't see that. Is Ranking a calculated column? What's the DAX for it?

Try:

ValMin = CALCULATE([Prom Valued L2W]),ALLSELECTED(), Quiebre_8S[Ranking]=1)