Forum Discussion
Using DAX summarize table to create column grouping using filtering and containsstring
Hi Anonymous ,
I found that you seem to be missing a comma between “Jog Mode” and "FILTER".
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-trend/ba-p/882970
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