cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## SELECTEDVALUE-1 not working in a measure

Hi All, i am trying to calculate the max value from a selected date and am using the below measure which is working fine

Max Peak Value Selected Date A =

CALCULATE (

MAX (TableXYZ[Col B]), TableXYX[Col A] = "123"

&& TableXYZ[Reporting_Date] = SELECTEDVALUE ( 'Calendar Dim'[Date] ) )

I now want to calculate the max value for the day before the selected date and when i put in a SELECTEDVALUE ( 'Calendar Dim'[Date] )-1 i get blank

Max Peak Value Selected Date A =

CALCULATE (

MAX (TableXYZ[Col B]), TableXYX[Col A] = "123"

&& TableXYZ[Reporting_Date] = SELECTEDVALUE ( 'Calendar Dim'[Date] ) -1)

i have created a measure and seen in a card i am getting the previous date to the selected one - Selected Date - 1 = SELECTEDVALUE('Calendar Dim'[Date])-1

i dont understand why it isnt working in the measure. thanks amrita

1 ACCEPTED SOLUTION
Frequent Visitor

this worked:

Max Peak Value Selected Date - 2 =
Return
CALCULATE (
MAX (TableXYZ[Col B])
, TableXYX[Col A] = "123",
FILTER(ALL(TableXYZ),TableXYZ[Reporting_Date] = _t2)
)
6 REPLIES 6
Frequent Visitor

this worked:

Max Peak Value Selected Date - 2 =
Return
CALCULATE (
MAX (TableXYZ[Col B])
, TableXYX[Col A] = "123",
FILTER(ALL(TableXYZ),TableXYZ[Reporting_Date] = _t2)
)
Community Champion

``````Max Peak Value Selected Date A =
VAR selected_date =
SELECTEDVALUE ( 'Calendar Dim'[Date] ) - 1
RETURN
CALCULATE (
MAX ( TableXYZ[Col B] ),
TableXYX[Col A] = "123"
&& TableXYZ[Reporting_Date] = selected_date
)``````

BR,

Samarth

Best Regards,
Samarth

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

Frequent Visitor

Hi that is still returning blank.

Community Champion

@amrosullivan , I am hoping you have checked the data and It have some data for selected date..right?

You could also try this:-

``````Max Peak Value Selected Date A =
VAR selected_date =
SELECTEDVALUE ( 'Calendar Dim'[Date] ) - 1
RETURN
CALCULATE (
MAX ( TableXYZ[Col B] ),
FILTER (
TableXYX,
TableXYX[Col A] = "123"
&& TableXYZ[Reporting_Date] = selected_date
)
)``````

Best Regards,
Samarth

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

Frequent Visitor

this is returning blank too.

i do have data for the previous date. when ir emove the - 1 and select the previous date i det the required value.

thanks!

Community Champion

@amrosullivan is it possible for you to share your PBI after removing sensitive data?

Best Regards,
Samarth

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

Announcements

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors