Forum Discussion
Solved
filter by group by
Hi Everyone, I need help creating a group by the table and use it to filter my data. The table has two columns; the name of the firm and Certification type and what I would like to do is create a tab...
- New Table =ADDCOLUMNS (VALUES ( Data[Firm] ),"@Certification",CALCULATE(IF ({ "SBE" }IN VALUES ( Data[Certification] )&& { "DBE" } IN VALUES ( Data[Certification] ),"SBE-DBE",DISTINCT ( Data[Certification] ))))
- New Table V2 =ADDCOLUMNS (SUMMARIZE(Data,Data[Firm],Data[Status]),"@Certification",CALCULATE(IF ({ "SBE" }IN VALUES ( Data[Certification] )&& { "DBE" } IN VALUES ( Data[Certification] ),"SBE-DBE",DISTINCT ( Data[Certification] ))))
Fowmy
Super User
Super Userbenjellounm
Create the following table. This will summarize by Firm not only SBE-DBE but whatever multiple rows per firm.
Let me know if this works for you.
New Table =
VAR __TABLE =
SUMMARIZE(
TABLE8,
Table8[Firm name],
"CERTIFICATION",
CONCATENATEX(
DISTINCT( Table8[Certification] ),
Table8[Certification], " - "
)
)
RETURN
__TABLE