As you didn’t provide the sample dataset and you didn’t tell about your measure formula I just consider a sample dataset on my own to simulate your problem.

Consider following screenshot with data and calculated columns.

enter image description here

Here the DaysFromToday calculate the Day difference from Today to for every column if the corresponding value in ‘SomeValue’ field reached a certain number. SomeValue is also calculated field that you can replace with your own calculation.

To get the single value from DaysFromToday you can have a measure which will give you MAX or MIN (of course some others functions if you need) of the column values like following screenshot – enter image description here

Yellow highlighted is the DAX way of mentioning a field name with the table name that you are missing in your formula.

Lastly the MAX or MIN measure can be displayed in the report like following –

enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top