Forum Discussion
Measure Calculation
Hello, I am trying to calculate the percentage of total sales of a particular product through different puchasing avenues, and different locations for each month. I have a table that is set up fo...
The measure you have is removing the filter for avenue, which you want to keep right?
One solution is to simply add another argument to the ALLEXCEPT Filter:
(CALCULATE(SUM('Sales'[Transaction Ammt]), ALLEXCEPT('Sales','Sales'[Date], 'Sales'[Avenue])))