How to get average gap through filter
Dear friends, i want to get gap from average score from all year data, but the data can't read because my slicer require single selection of year. Score 2021 = 5.00 Score 2020 = 3.50 the gap score i want to show is 1.50, but if year select is 2021, 2020 data will not be calculated. here is the pbix file : https://drive.google.com/file/d/10Gpy0UJmCDTovC8NJ25OtS5divb-QDmq/view?usp=sharing Thanks for help
