Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
@NewPBIe ,
Can you try this formula?
Measure =
IF(
ISBLANK([All Completed Tasks] / [All Tasks]),
0,
CALCULATE(
[All Completed Tasks] / [All Tasks] * 100,
FILTER(
'Table 1',
'Table 1'[Year to fiscal year] = MAX(Calender[Fiscal Year])
)
)
)
Thanks,
Arul
Thank you Arul,
unfortunately is the Table 1 not reachable from the measure:
I can only reach this "'Heutiges Datum' but no Field in the Table 1.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.