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
    )