Forum Discussion

bobby27's avatar
bobby27
Frequent Visitor
6 years ago
Solved

Row context not overriding in calculate function

  I have created a measure using the calculate function, it does not override the row context of the Attainment and always just returns the row total (see left hand table in linked page) I'm just st...
Need Help
  • bobby27's avatar
    bobby27
    6 years ago

    Hi Parvinder, Ken,

     

    I have solved my problem, It was similar to this problem here https://www.sqlbi.com/daxpuzzle/unexpected-filter-behavior-in-calculate/ and I sorted it by adding an explicit all to the calculate function for the attainment index column I was using to sort the attainment:

     

    CALCULATE([Pupil Count],Sheet1[Attainment]<>"No Data",ALL(Sheet1[Attainment_Index]))

     

    Thanks for your time.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

bobby27 something obvious is missing, share pbix file wiht sample data, remove sensitive info before sharing. you can also send it by email, my email is in the signature.

bobby27's avatar
bobby27
Frequent Visitor
6 years ago

Hi Parvinder, Ken,

 

I have solved my problem, It was similar to this problem here https://www.sqlbi.com/daxpuzzle/unexpected-filter-behavior-in-calculate/ and I sorted it by adding an explicit all to the calculate function for the attainment index column I was using to sort the attainment:

 

CALCULATE([Pupil Count],Sheet1[Attainment]<>"No Data",ALL(Sheet1[Attainment_Index]))

 

Thanks for your time.