Using DAX summarize table to create column grouping using filtering and containsstring

[Anonymous]

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 below formula is successful, however fails when I add additional filtered columns. i only want to filter and group the message the count column is not required.

Any support would be greatly appreciated, thank you.

Result Message required- Count colomn not required.

Cannot seem to add additional filtered columns

[v-eachen-msft]

Hi @Anonymous ,

Has your problem been solved?
If your problem has been solved, you could accept the reply you like.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

---

---

I found that you seem to be missing a comma between “Jog Mode” and "FILTER".

[Anonymous]

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.

[amitchandak]

Use like

calculate(countrows(Alarm),Filter(Alarm,<Clause>))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

@amitchandak  I am wanting this to be a new table.  This looks like it is a measure within an existing table?

[amitchandak]

You have to use calculate or IF to create the measure or dimension member in summarize

If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Anonymous]

@amitchandak Thank you, simplified example below of what I am trying to achieve.

1. Detailed table

2. Would like to create a summary table to group the detailed table by animal type. For example a column for dogs, cats - etc. I can successfully create a summary table for text containing Dog but having trouble adding additional columns.

3. Required Result - Column for each defined containstring.

Thanks