Ignore slicer filter on measure data

[ravikora]

Thanks Krishna.

I was actually already tried with REMOVEFILTERS() and ALL dax functions but not worked.

As requested, i came with short and clear data with below tables to understand everyone ease on my requirement.

Table 1- DIM

Id, Date, Period
1 1/1/2020 Jan
2 1/2/2020 Feb
3 1/3/2020 Mar
4 1/4/2020 Apr

Table 2 - FACT

Period_Id, Name, TotalSales, AverageSales(TotalSales/SlicerSelectionCount), AvgLTD(Totalsales/TotalPeriodCount)
1   Product1   120   60     30
2   Product2   400   200   100
3   Product3   30     15     7.5
4   Product4   200   100   50

Slicer used to filter data:

Period
Jan
Feb
Mar
Apr

1. Both Table 1 and 2 has inner join on 'Id' and 'Period_Id' 

2. In this sample 'AverageSales' are calucalted for 'Jan-Feb' period selection from slicer.

3. 'AvgLTD' calculated on 'TotalSales/TotalPeriodCount'

My requirement is, measure 'AvgLTD' should be unchanged/constant with regardless of slicer selection.

Can anyone please help me for solution?

Thanks,

Ravi

[nandukrishnavs]

@ravikora 

Try to use REMOVEFILTERS() or ALL()