PowerPivot Forum

Hi waynegolds, The sentence is a bit confusing, the text in the Excel book is a bit different: Position your tables so that any data tables (there is only one in this case) are at the bottom of the screen and the lookup tables are at the top. There is also an additional box with the following descri...

Hi, Hard to get the full picture without seeing the model. Any chance you can post an example file? Even a few screen shots to help understand the explanation. Can you post the actual measure for [% GWE Allocated Cost]? When you tested the measures to know they are independently correct, are you usi...

Hi NurlanPPF, Power Query takes a row based approach, and as such, having a result with merged cells is not possible. Can you review and revise your Summary to show the desired output with data only in a single row? Note, that the desired output may be achieved using a Pivot rather than just the tab...

Hi there, Providing a sample file would help with proposing a solution, so if that is possible please post one up. I am making an assumption that the columns of the data are the same across the 30 pages, just the column headings are different. If that is correct, insert a step to demote the headers ...

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...

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/