Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@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())
@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())
thank you @amitchandak, it worked beautifully.
Why can't you use Filter function in the syntax in this case?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |