Group calculated measures

[bilingual]

Hi, i have made a measure which calculates percentage of total:

Pct. af total = DIVIDE(SUM(Data[Antal rejser]);CALCULATE(SUM(Data[Antal rejser]);ALL(Data[Name]));BLANK())

I want to create a new group which sum up all calculated values which are less than 0,5 pct and call the group "Names with <=0,5 pct.", all other values just keep their Names, how do i manage it? 

Kind regards Dan

[v-henryk-mstf]

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

[Greg_Deckler]

@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
  )

[bilingual]

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

[StefanoGrimaldi · Accepted 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: 

Table = DataTable("Name", STRING,  

               "null", STRING  ,{  {"1","0"}  }  )  

and the measure have home section to define in the table you want to home it them apply greg indstructions for the measure itself, or use the Dax estudio or tabular to create the group. 

[StefanoGrimaldi]

you can use calculation groups on power BI dax studio or tabular editar: 

- https://www.youtube.com/watch?v=_j0iTUo2HT0

- https://community.powerbi.com/t5/Community-Blog/How-And-When-To-Use-Calculation-Groups-In-Power-BI/b...