Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
85 | |
85 | |
67 | |
49 |
User | Count |
---|---|
133 | |
113 | |
100 | |
68 | |
67 |