The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All!
I have created a paginated report using a Power BI Dataset as data source that contains a tablix with fields from 2 datasets. One is a header level and the other a detail level. The 2 fields from the header level do exist on the detail level, but the matrix sums weren't working correctly, and I was able to fix that in the desktop version of the report, by spliting the header level fields into a header level table.
On the paginated report, however, I haven't been able to get it to work. I have parameters from the detail table cascading into both datasets as dimension parameters; I am also using the lookup function for bringing in the 2 fields from the header table into the tablix with mostly detail table fields. This is the lookup function formula I am using:
=Lookup(Fields!Join.Value, Fields!Join.Value, Fields!contract_value_total_amount.Value, "ProgressPaymentsHeader")
The join column in both tables is a composite key I created to be able to join those tables together in my Power Bi Desktop model. The relationship is a Many to one, being many of]n the detail table.
My sums for the 2 fields coming from the header table are the same now as they were when I was pulling them from the detail table; they are incorrect.
My tablix looks like this and contract and funded value are my fields from the header table.
I have tested creating a new tablix getting all fields from the header table and my sums are correct there.
I believe the parameters are just not working correctly, likely, something wrong I did, but I have no idea how to fix this. I have tried innumerous things! Please help!
Thank you!
Solved! Go to Solution.
@Anonymous , after more research and trying different things while validating the data, I realized that my problem was not my parameters, but the sum. I will be creating a new post regarding this. Thank you for your help!
Hi @tharris ,
Is the total value incorrect when your paginated report apply the parameters? Could you please provide relevant screenshots? The screenshots need to include some data and mark the location of the wrong value. At the same time, please provide that how you set these parameters. In addition, you can refer to the content in the link below regarding the parameter setting.
Report parameters in Power BI Report Builder
Power BI Paginated Reports: Working with Parameters
Best Regards
@Anonymous , after more research and trying different things while validating the data, I realized that my problem was not my parameters, but the sum. I will be creating a new post regarding this. Thank you for your help!
User | Count |
---|---|
5 | |
5 | |
2 | |
2 | |
2 |
User | Count |
---|---|
10 | |
7 | |
4 | |
4 | |
4 |