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] )
)
Hi,
Unfortunately that still did not work, but I found this solution worked:
Region Median =
CALCULATE (
[Median] ,
ALL(DataTable ),
VALUES ( 'DataTable [Region] )
)