The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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
Thanks. Will take a look.
Maybe I should remove the totals and create them in Report Builder?
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |