topic Re: DAX measure for Excluding/Filtering Out Some Column String Values in DAX Commands and Tips

DAX measure for Excluding/Filtering Out Some Column String Values

Anonymous — Wed, 31 Aug 2022 15:19:43 GMT

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.

Re: DAX measure for Excluding/Filtering Out Some Column String Values

Kriekis — Wed, 31 Aug 2022 16:40:05 GMT

Hi,

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

It will befiltered out then.

/Andris

Re: DAX measure for Excluding/Filtering Out Some Column String Values

Anonymous — Wed, 31 Aug 2022 17:08:30 GMT

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.

Re: DAX measure for Excluding/Filtering Out Some Column String Values

Kriekis — Wed, 31 Aug 2022 18:10:56 GMT

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

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