Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
cflynn_29
Helper I
Helper I

DAX Returning Total vs Last Date

‎12-12-2022 11:41 AM

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

 

Message 1 of 5
373 Views
0
4 REPLIES 4
cflynn_29
Helper I
Helper I

‎12-13-2022 09:54 AM

I get the following on basic filtering 

cflynn_29_0-1670954079924.png

 

Message 5 of 5
301 Views
0
FreemanZ
Super User
Super User

‎12-12-2022 01:58 PM

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

Message 2 of 5
329 Views
0
cflynn_29
Helper I
Helper I
In response to FreemanZ

‎12-12-2022 02:12 PM

Same Value

Message 3 of 5
322 Views
0
FreemanZ
Super User
Super User
In response to cflynn_29

‎12-12-2022 02:30 PM

choose basic filtering then check 2030 only?

Message 4 of 5
316 Views
0

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.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All