Forum Discussion

inesj's avatar
inesj
Frequent Visitor
4 years ago

Underlying Data Export not applying filters

Hello everyone,   For some reason, the data export obtained through the "Export Underlying Data" functionality is not applying the filters selected by the user in the report, and I cannot seem to f...
Need Help
andercfaria's avatar
andercfaria
New Member
3 years ago

+1 to this issue

I have the following scenario:
All pages filter with Country = 'Brazil'

Upon exporting underlying data of the following measure:

Comp. Rate = FORMAT(
DIVIDE( 
    CALCULATE(
        AVERAGE('Bonus'[Compa-Ratio]),'Bonus'[PDP Rating] = "Exceptional"
    ),
    CALCULATE(
        AVERAGE('Bonus'[Compa-Ratio]),'Bonus'[PDP Rating] <> "Exceptional"
    )
), "0.00")


Instead of showing me the data related to Brazil that made the measure, it shows me data of all countries instead.

Note: With the page filter it works, when I'm using all pages filter it doesn't.