Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter on Data or Power Query or DAX

I want to filter a characteristic value. 

I'm not sure which side should I filter them. 

I thought if I make it on Power Query, it will extend the refresh time.

Actually I don't know about data side. Does it affect the performance ?

Creating measure with DAX ?

 

I want to find out your preferences. In which cases do you use which one ?

(* I mean that the icon was shown  on left bar, which named as 'Data')

  • Anonymous , if you do not need that value for analysis then filter that in power query. Or even create a new column with filtered value.

     

    If you need it for analysis filter in Dax/measure

2 Replies

  • Anonymous , if you do not need that value for analysis then filter that in power query. Or even create a new column with filtered value.

     

    If you need it for analysis filter in Dax/measure

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    It depends on your need. You want filter affect the data, visual or formula? If you want filter the data that you don't need, Power Query will be a good choice.

     

    Best Regards,

    Jay