Forum Discussion
DAX - 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 ...
If 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 .
I got the filter part.
But now, my conecern is the disctinct values. I need to consider the name / roll num column for taking distinct values right. I can have 2 students getting same marks. If I take marks as distinct, my result will go wrong, right?
My aim is to consider the distinct values of name/roll num and calculate the average.
The dax you shared is helping close to the results, But I am concerned about the Distinct part. Please help me