Forum Discussion

PradeepDive's avatar
PradeepDive
Helper II
5 years ago

HasOneFilter Issue

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. 

Formula
HASONEFILTER
Help