Forum Discussion

wilson_smyth's avatar
wilson_smyth
Icon for Post Patron rankPost Patron
8 years ago
Solved

two different granularities

Im trying to get data at two different granularities. Its easy at the lowest granularity, requires no extra work, but to create a measure to always get the count at a higher granularity is eluding me...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You cannot open the filter of CourseInstance. because the courses are linked to that.  You should only open all Students.  This too would work

     

    =if(ISBLANK([doc count]),BLANK(),CALCULATE([doc count],ALL(Student)))

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

This measure works

 

=if(ISBLANK([doc count]),BLANK(),CALCULATE([doc count],ALL(Student[studentname])))

 

Hope this helps.

 

  • wilson_smyth's avatar
    wilson_smyth
    Icon for Post Patron rankPost Patron
    8 years ago

     

     

    hi ASHISH_MATHUR


    This does indeed work, thanks! it does however demand that i list all dimensions in the calculation if i dont want it grouped by them. 

     

    I assumed ALLEXCEPT would remove all filters from all dimensions, except what i specified, in this case ALLEXCEPT(course, course[course]), but it doesnt work as i expected.

     

    Id like to understand why allxcept doesnt operate as i expect, i.e.  why

     

    ALL(students), ALL(CourseInstance)  != ALLEXCEPT(course, course[course])

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      You cannot open the filter of CourseInstance. because the courses are linked to that.  You should only open all Students.  This too would work

       

      =if(ISBLANK([doc count]),BLANK(),CALCULATE([doc count],ALL(Student)))

      • wilson_smyth's avatar
        wilson_smyth
        Icon for Post Patron rankPost Patron
        8 years ago

        apologies for the delay in responding.

         

        I dont fully understand the statement "You cannot open the filter of CourseInstance. because the courses are linked to that.  You should only open all Students."

         

        if i created a calculated column containing course, on courseInstance would that mean i can filter on course instance?