Forum Discussion

pstanek's avatar
pstanek
Post Patron
10 years ago

Page Level Filters and DAX

Is it possible to connect Page Level Filters with Dax code? Page Level Filters will determine value of the parameters.

Need Help

5 Replies

  • waltheed's avatar
    waltheed
    Impactful Individual
    10 years ago

    Hi pstanek,

     

    Can you clarify your question a bit?

    - What do you mean with conect?

    - What parameters do you mean?

     

    You can check what the filtered values are in your DAX expressions, e.g. with the ISFILTERED() function.

    All filters are included in the filter context that is used for evaluating your DAX expressions.

     

    • pstanek's avatar
      pstanek
      Post Patron
      10 years ago

      Simple example

      I have Page Level Filter

      Name action

      1

      2

      3.

       

      I would like to create Measure=2+ Name action

      When page level filter is 2 then measure is 4.

       

      The other thing is , I would like to create dynamic table, when table depends on Name action value.  I mean it as filter So I don´t know how. Maybe It is not possible

      • pstanek's avatar
        pstanek
        Post Patron
        10 years ago

        Dynamic table

        I mean this

        Name action startdate endate

        1                   date1       date11

        2                   date2        date22

         

        IF page filter is 2, them l would like to have dynamic filter  value set from date2 to date22.