Forum Discussion
Filter not showing what expected
Hello all. I have two tables and one filter. The first table shows information about product value for every year and the second table shows countries that exported selected products from the first t...
AllisonKennedy
Community Champion
Community ChampionYou may need to create a measure for the $ calculation that uses the ALL() function to calculate the total for all prices.
Total = CALCULATE(SUM(column), ALL(filteredvalues))
Total = CALCULATE(SUM(column), ALL(filteredvalues))
Thanks for your reply however it did not work for me