Hi All,
I am creating a drillthrough button in my report and for which I am using HASONEFILTER to see if a filter is applied or not.
I also have a slicer (dropdown) in my page. Basically what the formula does is checks if user selects a value from the slicer and if selected it give me a page name. The page name is used as a navigation to drillthrough page. Below is my DAX
MyDrillthrough Navigation =
Var _isValueSelected = HASONEFILTER('Project List'[ORG])
Return
IF(_isValueSelected ,"Details Page","")
I one slicer dropdown for 'Project List'[ORG]) and another visual of a small metrix table as 'Project List'[ORG]) and Cost
So now the strange part, when I select ORG from dropdown the drillthrough button doesn't work. BUT if I select ORG from the metrix visual then the drillthrough button works...
I am sure dropdown is the issue ? Does HASONEFILTER doesn't work with slicers ?
Please help.
