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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AndersMadsen
Helper I
Helper I

Dax, ytd on select measure returns blank values when grouped by month

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()) 

 

 

image.png

And if  anyone knows it, how do I start my values from January?

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @AndersMadsen,

 

Can you share a dummy sample? It's hard to debug without data.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AndersMadsen
Helper I
Helper I

*pushes to top due to updates*

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.

Top Solution Authors