Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX measure for Excluding/Filtering Out Some Column String Values

Hi all,

 

I have this bar chart, but I want to be able to filter out some bar because I dont need those information to show, example showing the recently completed project. How do I write a DAX measure to exclude this. Thanks in advance.

 

 

3 Replies

  • Kriekis's avatar
    Kriekis
    Frequent Visitor
    4 years ago

    Hi,

    You can <Right click> on a bar and <Exclude>.

    It will befiltered out then.

     

    /Andris

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Kriekis 

      This particular way will not work because it would not provide a permanent solution. That's why I thought a DAX measeure will be the best to create new table or column that will exclude that particular value.

  • Kriekis's avatar
    Kriekis
    Frequent Visitor
    4 years ago

    Then Your measure looks like this:
    calculate (
       <your calculation>,
       Status <> "03 - Recently Complete"
    )

     

    or alternatively You can filter out those rows in Power Query.