Forum Discussion
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 only for where there are Country Median values, essentially removing all the blank Country Median rows?
Region Median Formula Used:
E.g.: Only displaying Countries G, L, O and R
Thank you.
Hi,
Unfortunately that still did not work, but I found this solution worked:
Region Median =
CALCULATE (
[Median] ,
ALL(DataTable ),
VALUES ( 'DataTable [Region] )
)
4 Replies
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
Hi,
Unfortunately that still did not work, but I found this solution worked:
Region Median =
CALCULATE (
[Median] ,
ALL(DataTable ),
VALUES ( 'DataTable [Region] )
)
