How could I add multiple columns at once in PowerApps

Hi I am having the data in sharepoint like

Now I have to create a piechart in PowerApps Showing the Percentage of Each title.

So, I am creating a new column using AddCoulmn(GroupBy,"Title", "Grouped"), "Titles", CountRows(Grouped))

Now I want to create another Column with the distinct titles and its percentage with reference to the ID.

How can I do that?

1 Answer

The AddColumns function can add multiple columns at once. For example, the expression below can be used to add a percentage in addition to the number of titles in the grouping that you have.

With( { totalCount: CountRows(dataSource) }, AddColumns( GroupBy(dataSource, "Title", "Grouped"), "Titles", CountRows(Grouped), "TitlePercent", 100.0 * CountRows(Grouped) / totalCount))