Unanswered

Total Sum Row HTML Table from Power BI

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I'm trying to create a HTML table from Power BI data. The table like below is something I am trying to achieve, with the bottom row having the total data. I have to be careful of the % measures as they cannot simply just be summed up.

Currently I only have the table without the total sum row.

How can I go about adding it?

Many thanks!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Implement your logic in DAX. Create a Power BI visual that has the desired format and then borrow its DAX for the Power Automate "Run a query against a dataset" action.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey thanks for your input! Do you perhaps have more specific steps to follow? I keep meeting with errors. Thanks!

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Grab the "First Table Rows" attribute rather than the full result object when you initialize the variable.

Was this reply helpful? Yes No