Make a measure only dependent from the year

[Clout]

Hello guys, I have two measures with the same function which I want to visualise in a card:

JSM_21d = DIVIDE(SUM('Flow'[AK_QT_d_21d]), COUNT('Flow'[AK_QT_d_21d])) * 365))

But I want that the outcome of this measure is only dependent of the year, and should not be calculated for every day because it only makes sense if I look at the whole year.

So I want to show in a card the year which is part of the date and the two measures.  As you can see in the table the measures are filtered by the year and its giving me the right values. But if I visualise it in the cards, the measures arent filtering only for the year and its giving me the wrong value.

And this is how it looks when I choosed the whole date of my data:

So I wantto , that the cards are behaving like the table in the picture.

Thanks in advance!

[amitchandak]

@Clout , I had a doubt that there is no interaction between the card and the date slicer. Or Card measure uses all(Date)

can you check these two

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

[Clout]

Hello @amitchandak, sry I gave the wrong measure.

My measure is this:

JSM_21d = CALCULATE(DIVIDE(SUM('Flow'[AK_QT_d_21d]), COUNT('Flow'[AK_QT_d_21d])) * 365, ALLEXCEPT(Datum, Datum[Jahr]))

And when I use this measure it looks like the picture above because only the year is filtered.

And if I use the measure above in my first post, the measure is calculated for every time invervall. But I only want, that it changes when the time intervall is in a different year.

[amitchandak]

@Clout , this will allow filtering Datum[Jahr]

refer

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Clout · Accepted solution]

Thank you for your suggestion @amitchandak.

I solved it now with a calculated column instead of a measure with the same DAX function and then I put the calculated column as a average in the card visual.