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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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*