Measure filtering the visual, but when exporting the data from visual to excel, data is not filtered

[cbolling]

Hi All,

Here is a measure I created:

NEW SURGEON =

VAR LastSaleDateSlicer = CALCULATETABLE ( LASTNONBLANK ( DimDate[MonthFirstDay], 0 ), ALLSELECTED(FactSales))

VAR DateDifference = DATEADD(STARTOFQUARTER(LastSaleDateSlicer),-3,QUARTER)

RETURN

SWITCH(TRUE(),

SUMX(

FILTER(FactSales, STARTOFQUARTER(DateDifference)>STARTOFQUARTER(FactSales[RevenueRecognitionDate])),

FactSales[Revenue])

<= 0

&&

SUMX(

FILTER(FactSales, STARTOFQUARTER(DateDifference)<=STARTOFQUARTER(FactSales[RevenueRecognitionDate])),

FactSales[Revenue])

> 0, "NEW",

"OLD")

I use this measure as a filter on a visual that is working. The visual filters correctly, but when I export to excel from the visual, the export gives me everything unfiltered. I have never had this problem, any help would be much appreciated.

Measure is filtering the table, but ehen exported the data is not filtered.

Thanks

[chudson]

Does anyone have any ideas why a measure filter would work on a visual in Power BI but export all the data basically disgregarding the applied measure filter?  We are seeing the same issue on a visual i have.

[Anonymous]

Hello @cbolling 
Can you share your pbix file after removing the sensitive data?

[cbolling]

In order for the measure to work the sensitive data must be a part of the PBIX. Unfortunately I cannot provide you with a PBIX file, is there anything else that I can share with you that could be of any help?

[cbolling]

Does anyone know why my data wouldnt be filtered the same way as in a visual when I export?