Forum Discussion
o59393
Post Prodigy
Post ProdigyHow to return unique column values with summarize with distinct
Hi all I created a table using summarize and distinct with intention to have unique combinations of the columns Tier 1 + Tier 2 and a percentage of 100%. However I am getting duplicate rows as...
I put this together, I "think" you want to do a summary and then a group by.
TableTest = var _tab = SUMMARIZECOLUMNS( Input[Tier 1: Process Facet], Input[Tier 2: Activity Facet], INPUT[Activity ID], "ID", MIN(INPUT[Activity ID]), "perC", MIN(INPUT[%]), "name", MIN(Input[Name]), "func", MIN(Input[Function]), "Area", MIN(Input[Area])//, ) RETURN GROUPBY(_tab, Input[Tier 1: Process Facet], Input[Tier 2: Activity Facet], "total", SUMX(CURRENTGROUP(), [perC] ))
HotChilli
Community Champion
Community ChampionI put this together, I "think" you want to do a summary and then a group by.
TableTest = var _tab = SUMMARIZECOLUMNS(
Input[Tier 1: Process Facet],
Input[Tier 2: Activity Facet],
INPUT[Activity ID],
"ID", MIN(INPUT[Activity ID]),
"perC", MIN(INPUT[%]),
"name", MIN(Input[Name]),
"func", MIN(Input[Function]),
"Area", MIN(Input[Area])//,
)
RETURN
GROUPBY(_tab,
Input[Tier 1: Process Facet],
Input[Tier 2: Activity Facet],
"total", SUMX(CURRENTGROUP(), [perC] ))
