DAX Fridays

In this video I will show you how to do a partial text search of multiple values using DAX! Great DAX lesson to learn how to manage multiple values.
I got asked to do this tutorial based on this power bi community thread:
community.fabr...
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@pilarbaldominos2505]

I love it! The nice part of your videos is you have ideas that they are simple to implement in different use cases. I will use that on Monday 😀 Thanks!

[@CurbalEN]

This was not my idea, i was asked about it but thanks!! :)

[@AdamZuk1982]

Great video for morning cofe ;). Thank You.

[@bradj229]

I LOOOOOVE the return of DAX Fridays! 🎉

[@CurbalEN]

❤️❤️

[@gennarocimmino]

Hi Curbal,
Great tutorial, thank you for sharing it

[@jon4]

The DAX approach to creating a dynamic slicer is clever, especially the workaround using COUNTROWS to handle multiple selections smoothly. It would be interesting to know the performance implications of this method on larger datasets.

[@CurbalEN]

Let us know if you test it in bigger datasets!

[@geineralbertomejiagarzon4034]

It's great. Maybe I would try to solve it from the source and/or model first, so that the DAX measure is not complicated, but if the business context does not allow it, this advice is excellent.

[@abhijeetghosh27]

WoW..WoW..WoW.. @Ruth.. This is just 👌👌😀 Just ♥ this.

[@CurbalEN]

😃

[@PicaPauDiablo1]

Thank you

[@HenriquedeAlbuquerque-x1x]

Thank you so much for the content you have been posting on RUclips Channel. May I suggest/ask something? Can you please teach us how to create a multilanguage Dashboard in Power BI?
I have been looking for something on Google, and RUclips and so far I couldn't find anything. Please, can you help me with this?
Thank you

[@Nalaka-Wanniarachchi]

Cool.Nice tips ....

[@ClemsonBrownie]

This is great! I actually JUST ran into a similar issue, but instead of OR when selecting values, I need it to be AND. Curious what your thoughts on adjusting the DAX to account for AND instead of OR.

[@ExcelInstructor]

1:05, a question if I may?
why not use advanced option and simply split it to rows?
it will then automatically create 1 column table.

[@CurbalEN]

Sometimes you need the data as is. Think ot was complete sentences from a questionnaire instead, you dont want to split them right?

[@ExcelInstructor]

@@CurbalEN ok, let me try asking other way around. You took your original table, made a reference to it, then you extracted unique values after splitting the text in the column.
Your way was to split it to another column and then combined the columns into 1 column and extracted the unique values.
So what Im asking is - why do it the long way around, when column split function can split it diresctly into rows,
so trying to fast recreate this:
let
Source = Excel.CurrentWorkbook(){[Name="name"]}[Content],
#"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Split Column by Delimiter", {}, "Attribute", "Value"),
#"Removed Other Columns" = Table.SelectColumns(#"Unpivoted Columns",{"Value"}),
#"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
#"Removed Duplicates"
this is mostly what you did.
so if you would @ 1:04 opened the advanced options, you would see option to split into rows,
so basicly this:
#"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Split Column by Delimiter", {}, "Attribute", "Value"),
#"Removed Other Columns" = Table.SelectColumns(#"Unpivoted Columns",{"Value"}),
would be replaced with just this:
= Table.ExpandListColumn(Table.TransformColumns(Source, {{"Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column1")