Forum Discussion
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 ...
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.
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:
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.
