Forum Discussion
Solved
Filter (DistinctCount) - DAX Newbie
Hey forum, I want to be able to create a measure that aggregates as a DistinctCount but only shows the value for the current year (including if I check in a year from now). Please Help, T...
Hello agd50 ,
you can use below calculation to achieve this:
Calculate(DistinctCount(Column), filter(Table, Year(Table[Date])= Year(Today())))
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
I agree thanks, but I assume that calculate is not neccessary in measures as that is already automatically included
On second thought this may not work for me as I forgot to mention dim_calendar is a separate table to the aggregation so I assume that a related/relatedtable which need to be included somewhere