First Date in a Slicer Filter Meassure

[ry22749]

Hello, I started using Power BI one month ago. I am really happy with this community.

I have the "Real" column. I want to compare each value with the value of 1/12/2018.

The meassure I created is this one:

 

Now, I added a slicer, so I want to compare each value with the first value on the Slicer. When I create a meassure that takes the min value of "Fecha" I get an error message. How can I solve this?

 

 

Thank you very much for your help-

[Mariusz · Accepted solution]

Hi @ry22749 

The below should do the trick.

Measure = 
VAR f = CALCULATE(
    MIN(Pautas_Macro[Fecha]);
    ALLSELECTED()
)
RETURN 
CALCULATE(
    SUM(Pautas_Macro[Real]);
    Pautas_Macro[Fecha] = f
) 

Regards,
Mariusz

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

[ry22749]

@MariuszWorked! Thank you!!

[Anonymous]

@ry22749 - 

You could use a variable to store the MIN value and then use it, like this:

Medida 2 = 
var min_date = MIN(Pautas_Macro[Fecha])
return CALCULATE(SUM(Pautas_Macro[Real]); Pautas_Macro[Fecha] = min_date)

Hope this helps,

Nathan

[ry22749]

@Anonymous Thanks for your help! But that meassure gives this: ("Medida3")