DAX measure for Excluding/Filtering Out Some Column String Values

[Anonymous]

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.

[Kriekis]

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

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

[Kriekis]

Hi,

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

It will befiltered out then.

/Andris

[Anonymous]

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.