I have below Power BI matrix which showing the sales performance by Customer (like Excel Pivot).
But I would like to show the sales Amt in HKD or in Local Currency depends on RSO selected in filter panel.
ie) if only DACH is selected, it should show in Local currency
if more than 1 RSO is selected, it can show in HKD
No need to apply any exchange rate as the raw data already had sales amt in local currency and sales amt in HKD
But i try to use if function to control it
Selected RSO Numbers= CALCULATE(DISTINCTCOUNT(‘DIM-Customers’[BU]),ALL(‘DIM-Customers’)
Sales Amt =if([Selected RSO Numbers]>1,[Sales (HKD)],[Sales (Local Currency)])
it always showing result in Local currency as I believe it due to table context. How can I ignore the table context and only use the selected RSO numbers for my DAX formula?