Forum Discussion

jayasurya_prud's avatar
jayasurya_prud
Advocate III
3 years ago

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? 

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

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 .

  • jayasurya_prud's avatar
    jayasurya_prud
    Advocate III
    3 years ago

    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