Forum Discussion
Power BI Group Total
I have mock dataset looks like below. On my visualization, I have two problems: 1) I am trying to show the total sales by group. - called "group total". But on my dataset, I have Item ...
Anonymous - How about these:
return = VAR __group = MAX('Table17'[Group]) RETURN CALCULATE(SUM(Table17[Total Sales]),Filter(ALLEXCEPT(Table17,Table17[Date]),[Item code]="/return" && [Group]=__group))group total = CALCULATE(SUMX(FILTER(Table17,[Item code]<>"/return"),[Total Sales]),ALLEXCEPT(Table17,Table17[Group],Table17[Date]))
Very minor tweaks.
Attached again, Page 5, Table 17.
PBIX would help but I'm thinking that you need to modify your ALLEXCEPT to include customer since you have a customer slicer?
Greg_Deckler Is there a way that I can send you the pbix file securely?