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 ...
Avg Marks = AVERAGEX(DISTINCT(Student_Marks[Marks]),Student_Marks[Marks])
Hello jayasurya_prud ,
Try Above Solution..... If it is helpful for you so please accept as Solution marks .
Thank You!
Try Above Solution..... If it is helpful for you so please accept as Solution marks .
Thank You!