The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
i have measure
Fact=
HI @Analitika,
You can take a look at the following blog to know how to use the 'if statement' to check the current row content level, then you can write a special formula as 'lbendlin' mentioned to handle the total level calculations.
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
Did you mean to use DATESYTD() ?