Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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,
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |