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".
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
amitchandak I am wanting this to be a new table. This looks like it is a measure within an existing table?
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/882970amitchandak 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