Using DAX from Power BI in Paginated Report

[grega]

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.

[Anonymous]

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

[grega]

Thanks.  Will take a look.

[grega]

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