Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I nee apply below filter in dax query.
Please help to accomplish this requirement.
How to apply filter with not like [%A-Z%] in DAX (SSAS tabular) + powber BI
Thanks
Solved! Go to Solution.
HI @joshikakrishna,
You can use below calculate column formula to create a variable dictionary table to compare with current text column:
Contains Text = VAR dict = SELECTCOLUMNS ( GENERATESERIES ( 97, 122, 1 ), "UPPER", UNICHAR ( [Value] ), "LOWER", LOWER ( UNICHAR ( [Value] ) ) ) RETURN COUNTROWS ( FILTER ( dict, SEARCH ( [UPPER], [Text], 1, -1 ) > 0 || SEARCH ( [LOWER], [Text], 1, -1 ) > 0 ) ) > 0
In addition, you can also take a look at following blog which mentioned dax string comparison:
From SQL to DAX: String Comparison
Regards,
Xiaoxin Sheng
I would recommend using the search function (https://dax.guide/search/).
You can post an example of your data and I'll try to help
HI @joshikakrishna,
You can use below calculate column formula to create a variable dictionary table to compare with current text column:
Contains Text = VAR dict = SELECTCOLUMNS ( GENERATESERIES ( 97, 122, 1 ), "UPPER", UNICHAR ( [Value] ), "LOWER", LOWER ( UNICHAR ( [Value] ) ) ) RETURN COUNTROWS ( FILTER ( dict, SEARCH ( [UPPER], [Text], 1, -1 ) > 0 || SEARCH ( [LOWER], [Text], 1, -1 ) > 0 ) ) > 0
In addition, you can also take a look at following blog which mentioned dax string comparison:
From SQL to DAX: String Comparison
Regards,
Xiaoxin Sheng
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |