Forum Discussion
Solved
Remove blank rows from matrix after using 'All' function
Hello, I've used the ALL function to remove all filters to provide a 'Region Median'. I've also displayed the Country Median in an adjacent column. However, is there a way to show the Region Median...
Hi,
Unfortunately that still did not work, but I found this solution worked:
Region Median =
CALCULATE (
[Median] ,
ALL(DataTable ),
VALUES ( 'DataTable [Region] )
)
Easiest way you can do this is selecting is not blank filter from the filter pane as below
Hello cThennakoon,
Thank you for your reply - I tried this, but it doesn't change the matrix at all - it's almost as if the ALL formula used for the EMEA Median values is preventing the filter from working. Is there any way to amend the ALL formula so that it doesn't show absolutely all countries included in the data source, and instead only ones with a Country Median value?
Looks like you did not click on Apply filter