Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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] )
)
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
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |