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 ...
Hi, 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?
