Forum Discussion
Cannot override Page Filter in Measure
- Anonymous4 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. - Anonymous4 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.
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.