Forum Discussion
Resolver IISummarize two columns from another table based on conditions
Hi community,
I have created a new table based on columns from a different table. Everything works fine except the last column "Total Hours 2" which does not summarize correctly, it gives the same result for each row. The "Total hours 2" syntax has to be tweaked. All other columns are correct. Do you have any suggestions on how to tweak the code?
I guess this condition has to be incorporated somehow in the above code?
Thanks in advance!
darko861 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try like
Total Hours 2 = calculate( sum(v_rpt_Service[Hours_Billable]) + SUM(v_rpt_Service[Hours_NonBillable]), v_rpt_Service[Date_Resolved_UTC]<>BLANK())
2 Replies
- amitchandak
Super User
darko861 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try like
Total Hours 2 = calculate( sum(v_rpt_Service[Hours_Billable]) + SUM(v_rpt_Service[Hours_NonBillable]), v_rpt_Service[Date_Resolved_UTC]<>BLANK())
darko861thank you amitchandak, it worked beautifully.
Why can't you use Filter function in the syntax in this case?