Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Discussion on filters

Hi all,

 

In four days i am going to start my new job as a BI Consultant and i wanted to dig in to an area that i have been thinking about for a while.

 

I my current job i came in to a Power BI solution where some DAX had been created but it was in my opinion very basic and therefore there was a high need for the filter pane to get the desired reults. Many times the DAX measures could have been extended just a little bit using CALCULATE and a few filters. Instead the DAX formula is only showing the basic and 3-6 filters had to be applied to the filter pane. An example is that every time i create a report i have to filter by OrderState, OrderStatus and ProductType (in the filter pane) and i always filter the same way.

 

What is your thoughts on this? Do you include filters in the filters pane and keep DAX simple or do you try to create DAX measures that take the common filters in to account and therefore have data that is more ready to use.

 

There is practically zero self service BI in my current job, but i am very sure that self service BI would benefit a lot from premade DAX formulas that cover filters. 

General Comment
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    If you are having the same filter every time, Put them as report level filter.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    Its upto your requirements.

     

    Incase you want to filter your page/visual using some filters then go for filter pane.

    If you are adding those filter at filter panel just  for filter out measure then it's better to add it in DAX only.

     

    Example.

    Lets say the report is always showing COuntry=USA sales data.

     

    If you add country column in filter panel ,user has to always select USA in filter panel.

    If you add filter condition in dax user need not to go to filter panel and select country.

     

     

    Above example is for static report that is USA sales.

    BUt if your report is being used by multiple users from multiple countries then it's better to use filter panel.

    and create simple dax.

    measure=Calculate(sum(table[Amount))

     

    add Country column and measure to table and check country wise sales by selecting country in filter pane.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.