Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Drill through button

Hi,  I have an overview page with multiple graphs. For example, I have a barchart with Sales data, a Categories graph and a Spend graph. They all have their own Page with details.  Now I want to cre...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Anonymous,

That was indeed helpful. 

I'm new to DAX and love to learn it, by looking it up but I couldn't figure this out.   

Using the example from the video I figured I could change AND to OR which works pretty wel. 

But I run ito two issues with changing the script from the video: 

 

1. How do I remove the slicers used in the video from the script? 

2. Is there a way to use the OR function with more than two options? 

 

I hope you can help me out, 

 

Thanks again! 

 

 

Drill Navigation with Page = 
VAR _spage =
    SELECTEDVALUE ( Navigation[Page name], "" )
RETURN
    IF (
        OR(
            HASONEFILTER ( 'Sales Territory'[SalesTerritoryCountry] ),
            HASONEFILTER ( Customer[Customer Name] )
        ),
        _spage
    )