Forum Discussion
Solved
How to filter sum function within Tablix using value within row
Im having trouble with power BI Report Builder for somthing that feels like it could be pretty simple but isnt and it may be because i dont understand how to refrence values that are in diffrent scop...
Hi gblanks ,
Based on your description, try the following steps:
- Create a Lookup Function: Use the Lookup function to match the job value in the current row with the job value in the Worked DataSet. The Lookup function can be used to retrieve a value from another dataset based on a matching field.
- Sum the Hours: Use the Sum function in combination with the Lookup function to sum the hours worked for the matching job.
Like below formula:
=Sum(Lookup(Fields!Job.Value, Fields!Job.Value, Fields!HoursWorked.Value, "WorkedDataSet"))Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi gblanks ,
Based on your description, try the following steps:
- Create a Lookup Function: Use the Lookup function to match the job value in the current row with the job value in the Worked DataSet. The Lookup function can be used to retrieve a value from another dataset based on a matching field.
- Sum the Hours: Use the Sum function in combination with the Lookup function to sum the hours worked for the matching job.
Like below formula:
=Sum(Lookup(Fields!Job.Value, Fields!Job.Value, Fields!HoursWorked.Value, "WorkedDataSet"))
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.