Forum Discussion
Using DAX summarize table to create column grouping using filtering and containsstring
Hi, I would like to use a DAX formula to create column grouping due to the number of variable I need to group. When creating the summary table I can't seem to just create a filtered column. The b...
Hi Anonymous ,
I found that you seem to be missing a comma between “Jog Mode” and "FILTER".
Why don't you simply create measure like below
If(containstring (MAX(table[column]),"drive")= TRUE,1,0)
IN IF PART ONLY ADD OTHER CONDITION USING OR OPERATOR (||)
And then add it as visual level filter and set it to 1.
THANKS,
PRAVIN
IF it resolves your problem mark it as a solution and give Kudos.
If(containstring (MAX(table[column]),"drive")= TRUE,1,0)
IN IF PART ONLY ADD OTHER CONDITION USING OR OPERATOR (||)
And then add it as visual level filter and set it to 1.
THANKS,
PRAVIN
IF it resolves your problem mark it as a solution and give Kudos.