Hi,
It's my usual row / filter context conundrum, essentially two related tables.
I want the entire category to show in the pivot table and the related 'sales' figures from another table, not all of category have sales
so when dropped in they are filtered out and I like to still be able to see them, I've attached a workbook with 3 simple tables illustrating the point;
I've tried using ALL function as in
< measure:= CALCULATE(SUM(SalesTable[Sales]),ALL(RepTable[Sales Rep])) >
which of course doesn't work as it's sending the entire 'sales rep' to calculate. But it does give a full columns which can
be dropped in to sort of achieve what I want , I've saved a table showing this. I've tried using the ALL, Keepfilters and other's but am a bit stuck.
Richard.
Bookmarks