Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @SChap ,
I found that you seem to be missing a comma between “Jog Mode” and "FILTER".
Hi @SChap ,
Has your problem been solved?
If your problem has been solved, you could accept the reply you like.
Hi @SChap ,
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-tr...
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |