- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Group calculated measures
Hi, i have made a measure which calculates percentage of total:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

for going by greg suggestion to create a disconected table just make a table that returns a single column and row with null value and just that table as disconected,
example:
Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @bilingual ,
Whether the advice given by @StefanoGrimaldi has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@bilingual Create a disconnected table with your group names and a measure along the lines of:
Measure =
VAR __Table = SUMMARIZE('Table',[Name],"__Pct",[Pct. af total])
VAR __Group = MAX('DisconnectedTable',[Value])
RETURN
SWITCH(__Group,
"Names with <=0,5 pct.",SUMX(FILTER(__Table,[__Pct]<0,5),
// more categories here
)
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi Stefano, thanks however i have problems making the Disconnected table, i can not make it to list the names, how do i do it?
Kind regards Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

for going by greg suggestion to create a disconected table just make a table that returns a single column and row with null value and just that table as disconected,
example:
Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

you can use calculation groups on power BI dax studio or tabular editar:
- https://www.youtube.com/watch?v=_j0iTUo2HT0
Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!
Proud to be a Super User!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

User | Count |
---|---|
84 | |
81 | |
52 | |
37 | |
36 |
User | Count |
---|---|
104 | |
85 | |
48 | |
43 | |
41 |