Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
1.) I've created a list, from a Table, with several values :
2.) I created a Parameter and added this list (1) to it. Also with a default value "EBZH":
3.) Then I switched to my Query and added this Parameter to the ColumnFilter, via "Text Filters -> Contains....". My Goal is, to get all Rows which are matching to one of the values from the Parameter-List :
4.) A closer look into the data shows that only the default value "EBZH", from the ParameterList, was used a FILTER.
Alle the values from the List itself weren't applied to the filter:
Any idea what I have done wrong?
My Goal ist still to work with this Parameterlist for filtering, because I have 10 other Queries for which I have to use the same filter and I dont want that to do that by hand everywhere.
Many thanks in advance for all the support
Cheers
Alex
PS: M-Query "Contains" = SQL "IN" <= thats a least what I think I understud. If that wrang then please tell my that.
Solved! Go to Solution.
"List.Contains" was the correct solution.
But in my case it works only with a List and not with Parameter !
1.) I still used my List "List of Basen"
2.) I applyed the "Filter" as en extra M-Query statement via "Advanced Editor" in which I refered to the "List of Basen"
#"Filtered Rows7" = Table.SelectRows(#"Filtered Rows2", each List.Contains(#"List of Basen", [Basis])),
This blog post helped solved my problem :
@Anonymous ,
You may just change to List.
"List.Contains" was the correct solution.
But in my case it works only with a List and not with Parameter !
1.) I still used my List "List of Basen"
2.) I applyed the "Filter" as en extra M-Query statement via "Advanced Editor" in which I refered to the "List of Basen"
#"Filtered Rows7" = Table.SelectRows(#"Filtered Rows2", each List.Contains(#"List of Basen", [Basis])),
This blog post helped solved my problem :
Sorry for the late reply.
You suggested "List" as solution. But as far as I understud List.Contains will filter en existing list for specific values.
But what I want is to filter a table with values from a (Parameter)List which is embedded into a parameter called "ParBasen"
Cheers
Alex
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |