Issue with ALLSELECT
Hi I am fairly new to DAX and am having a problem doing an advance calculation. Without going into the full-blown explanation of cohort Surval Rate calculation, I have tried to focus on a small using which I think stems from an ALLSELECT statement I use. If someone can anyone please tell me what I am going wrong I would be extremely grateful! The table below explains my issue. In summary, the measure GC2 works but I have a problem with the measure GC3. I see this is because the measure X3 returns ZEROs in each row and not 0.816 in each row. However, the calculation works in measure X2 The formulas are: GC2=X2* Y2 GC3=X3* Y3 Where X2 and X3 are generated by the following formulas X2 = CALCULATE([GC1], FILTER(Allselected(SurvivalRate), SurvivalRate[GradeCode]=1)) and X3 = CALCULATE([GC2], FILTER(Allselected(SurvivalRate), SurvivalRate[GradeCode]=2)) You can open this link to my example file which I have published on my Onedrive account, but this table attempts to explain the issue.
