topic Re: Using DAX from Power BI in Paginated Report in DAX Commands and Tips

Using DAX from Power BI in Paginated Report

grega — Thu, 08 Jun 2023 10:41:28 GMT

Hi,

I hope someone can help. I have a report in Power BI that I have then used the DAX from a visual and have used it as a Dataset in Report Builder.

I have the following columns:

Product Name

Number of orders

Average product Unit Price

Total Sale value

It also includes the Grand Total value that automatically gets generated in Power BI. However, I have issues positioning it. As it always appears at the top of the table and is blank, connected tho the Product Name. Does anyone know how to resolve this?

Thanks,

Greg.

Re: Using DAX from Power BI in Paginated Report

grega — Thu, 08 Jun 2023 10:51:21 GMT

Maybe I should remove the totals and create them in Report Builder?

Re: Using DAX from Power BI in Paginated Report

Anonymous — Mon, 12 Jun 2023 02:08:44 GMT

Hi grega,

Perhaps you can take a look at the following link about using Dax expression in paginated report if it helps with your requirement:

Tips and tricks with DAX table functions in paginated reports - Simple Talk (red-gate.com)
Regards,

Xiaoxin Sheng

Re: Using DAX from Power BI in Paginated Report

grega — Tue, 25 Jul 2023 09:50:05 GMT

Thanks. Will take a look.