Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, i have made a measure which calculates percentage of total:
Solved! Go to Solution.
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:
Proud to be a Super User!
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
@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
)
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
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:
Proud to be a Super User!
you can use calculation groups on power BI dax studio or tabular editar:
- https://www.youtube.com/watch?v=_j0iTUo2HT0
Proud to be a Super User!
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
53 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |