Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
cflynn_29
Helper I
Helper I

DAX Returning Total vs Last Date

This might requrie a bit more infomration but does anyone know why this maybe happening?  I have a measure that is returning a total instead of returing the last year which is 2030 (in a card format) 

cflynn_29_0-1670874013106.png

cflynn_29_1-1670874058011.png

The card has the follwing date/year filter on it

cflynn_29_2-1670874083398.png

Not sure whats going on here? Please assist

 

4 REPLIES 4
cflynn_29
Helper I
Helper I

I get the following on basic filtering 

cflynn_29_0-1670954079924.png

 

FreemanZ
Super User
Super User

what do you get if you choose "is equal to" 2030

Same Value

choose basic filtering then check 2030 only?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.