I have a data table ('SALES') which basically consists of two columns, Date and Volume HOG.
Here is a glimpse. Notice that this is a table visual and I'm not showing all the rows but that the total is 47,408.
In the page I'm using I have a filter on the Date to show only the last 10 weeks. But I need a measure that returns always the unfiltered total of the column Volume HOG (=47,408) no matter what the date filter is.
So naturally I want to do : Volume HOG total= CALCULATE(SUM('SALES'[Volume HOG]), ALL('SALES'[Date]))
However, it doesn't work. The table visual correctly shows and sums up only the last 10 weeks but the measure I created, which should ignore and filters on the Date, returns the same result instead of 47,408. And I have no idea why... Can anybody help me?
Is there a way of doing this but then summing all by a specific group ? I have Filtered my table down by specific week and Branch I want a company total by the same group. When I use all it will just return the whole sum of the table I dont want that I want sum by group but for all branches.
Below is an example:
NNQ | 2836 | 10025
Branch Sales Company TY =
VAR TFW = SELECTEDVALUE('s_bgw'[week])
's_bgw'[week] = TFW