Is it possible to toggle the filter inside CALCULATE on and off?

[Anonymous]

Hi,

I am curious if it is possible to toggle one of the filters in Calculate for different reports.

Here is my measure:

LYDaySales = CALCULATE([SumSales]
            , DATESBETWEEN(vwCTSKUSales[FinalDate], min('Calendar'[LY 364]), MAX('Calendar'[LY 364]))
            , vwCTSKUSales[ProdGroupCalc] in values(vwCTSKUSales[ProdGroupCalc])
            , vwCTSKUSales[BuyerCalc] in values(vwCTSKUSales[BuyerCalc])
            , vwCTSKUSales[MajorCode] in values(vwCTSKUSales[MajorCode])
            , vwCTSKUSales[Region] in values(vwCTSKUSales[Region])
            //, vwCTSKUSales[VendorCode] in values(tbl_SKUBasic[VendorCode])  <--- Toggle
            , ALL(vwCTSKUSales)
            )

Thanks!

[parry2k]

@Anonymous if somehow you identify (may be with parmeter) which report you are in then you can put condition in the logic to change filter.

[Anonymous]

Hi!

Thanks for the response.

I did attempt to insert an IF statement, if (isblank(....),,) but it didn't do anything.

How to identify a report in power bi?  I am assuming like in Excel, I need to get the sheet name (?)

[sokg]

Why don't you create 2 measures and use each one in each report you want??

[Anonymous]

The end users don't like the idea on an already large report. 

I also tried creating a manual table to determine which measure to use with success, but the users pushed back on that idea as well.  Thus, I am resorting to this forum for alternatives.

[sokg]

Please look a technique described at the video link below

https://www.youtube.com/watch?v=Ua3PyCTIAHM

Hopefully this is what you are looking for!