Forum Discussion

Maikeru's avatar
Maikeru
Helper II
8 years ago
Solved

TOP N elements using Visual filter on measure

Dear team,   I am trying to create a Top/Bottom N list of sales by customers for which [Sales Total] are between a dynamic range of values chosen by the user. For this I would like to use the in-b...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Maikeru,

     

    I thought hard and found the measure doesn't change the context but the values. So I would suggest you add a calculated column to the table 'FACT_Sales'. Then it would be easy now.

    TotalSales =
CALCULATE (
    SUM ( FACT_Sales[Sales] ),
    ALLEXCEPT ( FACT_Sales, FACT_Sales[Customer] )
)

    TOP_N_elements_using_Visual_filter_on_measure

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Maikeru,

 

I thought hard and found the measure doesn't change the context but the values. So I would suggest you add a calculated column to the table 'FACT_Sales'. Then it would be easy now.

TotalSales =
CALCULATE (
    SUM ( FACT_Sales[Sales] ),
    ALLEXCEPT ( FACT_Sales, FACT_Sales[Customer] )
)

TOP_N_elements_using_Visual_filter_on_measure

 

Best Regards,

Dale

Maikeru's avatar
Maikeru
Helper II
8 years ago

Thank you Dale! It works like a charm!