CASE Statement to DAX

There has to be something else about this data model that I can't see that's causing this. At this point I don't know what else to suggest without seeing the actual pbix file myself.

FERPA Law stands in front of me and completion!  I will keep playing with it to see if I can find anything that stands out.  The column is grabbing the correct number.  They are all formatted the same as decimals with 2 digits after the decimal. If a person has 0 in both columns CGPA UG and GR it is pulling a 0 over into the new column.  

Not certain if this would have any impact but since its a registration report for the students each row represents a registration so if a student has 4 registrations for that academic year then they would have 4 rows showing the same information just different information in the course column.  

A slicer of [Academic Year] does change the number.  But how do I make sure that I am getting an average of distinct student CGPA.  Even though their name appears multiple times the CGPA value stays the same since its a year end CGPA. 

Try changing your measure to

Avg CGPA = AVERAGEX(
	VALUES(TableName[Student ID]),
	AVERAGE(TableName[CGPAMerge])
)

I still don't understand what's causing it to behave that way though. That slicer should work fine with that measure even if there's no year selected. Look, here's your sample data in a quick file I put together using the regular average formula. https://drive.google.com/open?id=0B9BEw2M_e_jvT2I0TWxKRTZpdjA

I have a card with the Avg CGPA measure and an Academic Plan slicer. They interact exactly as expected. Can you look at this and tell me what's different between my file and yours?

I am going through line-by-line and comparing to your setup.  Hoping that I would find something different to put an end to this nightmare but so far I have found nothing different.  The only thing is I have 270,000 lines but the format is the same as the sample file I gave you just with some students appearing 3 or 4 times per academic year.  

Ok so I just deleted all the slicers and recreated them and now its work. :smileyindifferent:

:smileyfrustrated:

this was just an awesome post than you for sharing bpcreditcard, mybpcreditcard.com