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] ))))
AllisonKennedy
Community Champion
Community ChampionDo you have a Dim table for Firm already?
Once you get that Firm table, relate it to the certifications table. Then you can add a column to it using DAX:
List of Certifications = CONCATENATEX(RELATEDTABLE(Certifications), Certifications[Certification], "-")
See sample file below signature.