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!!
Count of x YTD =
CALCULATE (
DISTINCTCOUNT ( 'x'[x] ),
FILTER (RELATEDTABLE(Dim_Calendar), YEAR(Dim_Calendar[Date])=YEAR(TODAY()
)
)
)
This worked exactly how I wanted it to, Thanks
This worked exactly how I wanted it to, Thanks