Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
intose
Frequent Visitor

Calculate YTD regardless off date slicers/filters

Hi

Have been trying for a while to create a measure to display total year to date regardless of any filters.

 

The goal for my dashboard is to display sliceble visualisations and at the same time display totals.

 

Started with this one but it filters...

 

Invoiced YTD 1 = TOTALYTD([Invoiced];Date[Date];ALL();"6/30")

Landed on this one that seems to work as intended.

 

 

Invoiced YTD = CALCULATE([Invoiced];DATESBETWEEN(Date[Date];STARTOFYEAR(Date[Date];"6/30");CALCULATE(MAX(Invoice[Dag]);ALL())))

Can anybody comment on if this is the right approach och if it can be done in a better way?

 

Thanx in advance

 

//Torfi 

 

 

5 REPLIES 5
lc_finance
Solution Sage
Solution Sage

Hi @intose ,

 

 

the problem with your first formula should be that there is no parameter for the ALL function: Power BI does not know on which table the filters should be removed.

 

You can try with the formula below:

Invoiced YTD 1 = TOTALYTD([Invoiced];Date[Date];ALL(Date);"6/30")

Does it fix your problem?

 

Regards,

 

LC

Interested in Power BI templates? Check out my blog at www.finance-bi.com

Hi,

Yes I have tried that, was my first thought but id did not do the trick.

 

By leaving ALL with out any field or table you clear all filters witch want in this case.

 

Thanx

//Torfi

 

Hi @intose ,

 

 

can you share a sample of the Power BI?

 

That would make it easier to help you,

 

LC

Hi,

Unfortunately not, this is customer data.

 

Maybe I can put together a sample version och comment... I'll get back on that.

 

Thanx for now 😉

ok!

 

let me know if you want any more help,

 

 

LC

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.