Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a measure which sorts a list of values, takes 95% of the list and selects the max value.
It works when I filter on time, so it can sort the list on days, weeks months etc.
What I am trying to do now is take this measure and filter it to show from the start of the year, and create another measure which shows the same measure last year, in the same graph so I can create a line chart and show them beside each other.
I am new to dax, and I can't seem to make it work, I get blank values on my days.
This is what I have now:
VAL952018 = CALCULATE([VAL95Day];Filter(ALL(DimDate);DimDate[DateValue]<DimDate[FirstDayOfMonth]);DATESYTD(DimDate[DateValue]))
It runs, but I get no values.
EDIT:
I continued trying out different things, I now have two Measures but for another calculation that just counts the numbers of rows that has "true" in the "solved" column.
I have managed to create one that picks up the values from last year, and one that picks up the values from YTD. Problem is when I group them by month I get no values on the YTD measure.
_SolvedLastYear = IF(AND(FIRSTNONBLANK(DimDate[DateValue];1) >= DATE(YEAR(YEAR(TODAY())-1);1;1);FIRSTNONBLANK(DimDate[DateValue];1) < DATE(YEAR(TODAY());1;1));[_SolvedPercentage];BLANK())
_SolvedYTD = IF(FIRSTNONBLANK(DimDate[DateValue];1) >= DATE(YEAR(TODAY());1;1);[_SolvedPercentage];BLANK())
And if anyone knows it, how do I start my values from January?
Hi @AndersMadsen,
Can you share a dummy sample? It's hard to debug without data.
Best Regards,
Dale
*pushes to top due to updates*
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.