Forum Discussion

ravikora's avatar
ravikora
Frequent Visitor
5 years ago

Ignore slicer filter on measure data

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

1 Reply

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion

    ravikora 

     

    Try to use REMOVEFILTERS() or ALL()


    If this is not helpful, please provide more details.

    Regards,
    Nandu Krishna

    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos 👍

    Proud to be a Super User!