Forum Discussion

Shad's avatar
Shad
New Member
3 years ago

visual level filtering and slicers Filtering

Hi All,

 

I have the following Revenue measure :

 

 

revenue = 
SUMX('Sales by Store',
    'Sales by Store'[quantity_sold]*'Sales by Store'[unit_price]
    )

 

 

 

why when I filter on store-Id on the slicer the revenue increases ? I don't understand (year is 2018 and no other changes are made)

 

*filters on Matrix visual level are : top 10 customers by Revenue + excluding: non customers*

 

Results as follows

before filtering : store 5 revenue= 9,291

After filtering on store_id : store 5 revenue= 15,453

 

 

 

Thank you for the help ! appreciated 🙂

 

 

 

 

 

Need Help

1 Reply

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    3 years ago

    I'd blame the Top N filter. 

    It filters based on Customer - but the sales measure loops on Sales by Store. 

    So it's basically Top 10 across all the stores and then filtered by the respective store. 
    But when you filter it using a slicer, it shows you Top 10 for that specific store.