Forum Discussion

cbolling's avatar
cbolling
Icon for Helper I rankHelper I
5 years ago

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

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    • cbolling's avatar
      cbolling
      Icon for Helper I rankHelper I
      5 years ago

      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's avatar
        cbolling
        Icon for Helper I rankHelper I
        5 years ago

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

  • chudson's avatar
    chudson
    Icon for Helper IV rankHelper IV
    5 years ago

    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.