Forum Discussion
Issue filtering a FullDate Hierarchy
Hi NielsDecoene,
How do you modify your measure with ALL(DateFull) ? In Power BI, ALL() function ignores all slicers and Visual/Page/Report filters.
Thanks,
Lydia Zhang
Hey Anonymous
Because, the measures are based on DateFull:
-We have the measure being sliced by the X-Axis (DateFull)
-We have the graph being filtered by the Slicer
So that concludes our DateFull being sliced from two points of origin to avoid Blank(s) to a degree we're trying to let the measures run correct if the data being supplied to the graph get's cut off to a certain degree.
An example :
We filter data (Visual level Filter 12 months) that means the only data my measure can access is those 12 months,
but if we have calcs going back in time we're crossing that boundary. Which results in 0 being returned by the measure.
By supplying ALL in the calculations we're giving our reach the access of our entire dimension.
So even if we want to view the data for the month, that's a year a go the measure still has those dates to work with.
I hope i'm being somewhat clear about it.
P.S. I've contacted the author about filtering the last 12 months out of it. It should be by adding my Flag to the values property of the graph. But alas even that does not work he'll look into it and try to push a fix in the next release.
- Anonymous9 years agoNot applicable
Hi NielsDecoene,
Would you mind sharing me the PBIX file or relevant screenshots via Private message? From Private message, I note that you have a new issue about Date Hierarchy, I test the TOP N filter and cannot reproduce your issue.
Thanks,
Lydia Zhang