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 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
Hi Anonymous ,
I found that you seem to be missing a comma between “Jog Mode” and "FILTER".
7 Replies
- amitchandak
Super User
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 Linkedinamitchandak 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-trend/ba-p/882970
- v-eachen-msft
Community Support
Hi Anonymous ,
I found that you seem to be missing a comma between “Jog Mode” and "FILTER".
- v-eachen-msft
Hi Anonymous ,
Has your problem been solved?
If your problem has been solved, you could accept the reply you like.
