topic Re: How to filter text column using Dax in DAX Commands and Tips

How to filter text column using Dax

Anonymous — Thu, 11 Aug 2022 11:16:44 GMT

I want to filter and show data according to the category. which should be filtered in my Table chart

Product_id	Product Name	Category
1	a	Mobile
2	b	Charger
3	c	Mobile
4	d	Mobile
5	e	Charger
6	f	Headset
7	g	Charger
8	h	headset
9	i	Mobile
10	j	Charger

I want to display whose category is Headset & Mobile

Re: How to filter text column using Dax

amitchandak — Thu, 11 Aug 2022 15:30:36 GMT

Anonymous , Create a measure and use that with product and product if in visual

calculate(countrows(Table), filter(Table, Table[Category] in{"Headset","Mobile"}))

Re: How to filter text column using Dax

Anonymous — Fri, 12 Aug 2022 09:34:12 GMT

Thanks Amitchandak, Its displaying count with category, but i want to display filter rows on that table Chart.

Re: How to filter text column using Dax

v-cazheng-msft — Tue, 23 Aug 2022 06:54:52 GMT

Hi Anonymous,

You may try this solution.

1 Create a measure like this

FilterTable = CALCULATE(MAX('Table'[Category]),'Table'[Category] IN {"Headset","Mobile"})

2 Add filters on this visual to show items when the value is not blank

In fact, you could simply use Filters pane to achieve it: just tick the category you need to show but leave other catetories unticked.

Attached the pbix file as reference.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun