Forum Discussion
jayasurya_prud
Advocate III
Advocate IIIDAX - Average only on Distinct Rows and with Year filter
Hi, I am working on DAX Query where I need to calculate the Average only from the distinct rows and with filter For example, this is my raw table Name Roll_no Year Marks a 1 2014 ...
jayasurya_prudAdvocate III
Advocate IIIHi, thanks for sharing,
But how to apply year filter on this. I need to calculate only for 2014. How apply filter for year?
And may I know why you have used marks column in the distinct? Shouldn't it be the name/roll num?
Mahesh0016
Super User
Super UserIf you want to show only 2014 Avg marks so you give visual level filter in filter by year to 2014. and why i use distinct marks column because of we want to avg of distinct mark so i have use column as a table .