Forum Discussion

bilingual's avatar
bilingual
Helper V
3 years ago
Solved

Group calculated measures

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
 

 

Need Help
  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    3 years ago

    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. 

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    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's avatar
      bilingual
      Helper V
      3 years ago

      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's avatar
        StefanoGrimaldi
        Resident Rockstar
        3 years ago

        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. 
  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    3 years ago

    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