Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot override Page Filter in Measure

Hello,   I have a ProjectID Page Filter applied so that all measures and graphs only report from ProjectID = 018CAD. There is only one measure I would like to measure the Total Hours across all th...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I have a test on my side, please modify your measure:

    Duration Total Hours Auditing Time AsString = 
    
    //override page filter at first
    VAR TotalMinutes = CALCULATE( SUM(Toggl[DurationTotalMinutes]),ALL(Toggl))
    
    VAR TotalHours =TotalMinutes/60
    return  if(ISBLANK(TotalHours),"0",if(TotalHours<0,(TotalMinutes & " m"),Round(TotalHours,0)) & " h")

    Output:


    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    To my knowledge, It's not possible to override page-filter but keep filter in slicer since the filters has priority.

    My workaround is to create a slicer for ProjectID instead of apply it to page-filter. And then select the interaction type as "None":

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.