Forum Discussion

Thiyagu's avatar
Thiyagu
Helper III
8 years ago

Disable aggregate

Hi All,   I have two tabs, first tab is full of slicers and second tab works based on slicer selection in first tab.   I have some slicers in tab 1, mainly fiscal period and periodic (MTD,QTD,YTD...
Need Help
Tips and Tricks
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Thiyagu,

 

There could be a trick of independent slicer table. Please check out the demo in the attachment. 

1. Create a new table as a slicer. Don't establish any relationship.

2. Create a measure like this.

Measure =
CALCULATE (
    SUM ( 'Fact'[Value] ),
    FILTER (
        'Calendar',
        'Calendar'[Date] <= MAX ( 'Slicer'[Date] )
            && 'Calendar'[Date] >= FIRSTDATE ( DATEADD ( Slicer[Date], -5, MONTH ) )
    )
)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Dale