PowerPivot Forum

Hi, thanks for following up. Still do not have it working with the slicer based on the Year column of the Calendar table. Hard coded it is fine, using the Calendar[Year] produces the correct result when I use a Card visual to test, so still stumped. Don't think the DateTime aspect mentioned is relav...

If you have a mock up model with fake data that would help, but see if this heads you in the right direction. Not sure I have the syntax right for this but some trial and error might get you there. Single Store Shopper = CALCULATE( COUNTROWS( FILTER( Customers[CustomerKey], CALCULATE( COUNTROWS( Tra...

Hmm, interesting. Thanks for investigating, will have a look at the file you posted tomorrow night or Monday. Not super keen on having a different field to use as the slicer, as am using this slicer linked across multiple pages and want it to be coming off the date table as it affects other calcs in...

Just came across this too:

Thanks for having a look. I cannot understand why the measure works when the FirstYear is hard coded to 2018 but not when I use the SelectedValue. The attached PBIX has the example with your formula. It is not producing the correct result. If you change Funding Amount Current Year measure to be hard...

See if this helps

https://powerpivotpro.com/2017/03/latest-best-way-catchcaptureinspect-slicer-selections/

Thanks for the suggestion. It seems like it should work based on what you provided, but the visual is showing results for more than the selected year plus two more (I did change the + 3 to +2). I tried hard coding the FirstYear value to 2018 in both measures and the result is as expected, so just ne...

Had a play with techniques from these posts: https://datachant.com/2016/01/13/split-and-unpivot-comma-separated-values/ https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/ For the No Splitting example, the final couple of steps should be able to be done without using Piv...

NurlanPPF wrote:Hello,
Is it possible to sum delimited values without splitting?

Please help!

Is there a reason you need to do this without splitting? Perhaps if this is understood can help re solution, as it can easily be done with splitting - see attached.


Cheers
Phil

Hi, I am looking to produce a visual that shows Funding over three years (slicer selected year and next two) for two different measures, in a stacked column chart. I have attached a PIBX and Excel files with example data, and my attempt at the two formulas. I have hard coded the VARs but I need them...