I know my question is crazy, but I just wonder to know if it is possible or any workaround on it.
My model will show Sales Amt in HKD or in local currency with below logic checking:
- If multiple currency (multiple RSO is involved) , sales $ will display in HKD
- if only single currency (RSO using same currency), sales $ will display in local currency.
(Using Calculated + distinct count+ allselected).
However, in my sales person comparison tab, I get two tables, 1) Sales by RSO (sales person), 2) Sales by Product Type
By default, as no RSO or no sales person is selected, both table will show in HKD.
But when I select any sales person in the first table, as it become filtering the RSO and sale person, my second table will show sales in local currency, logically it is correct, but it is very confusing as first table still show sales in HKD, but second one is show in local currency.
Is it possible to have a DAX to keep second table show in HKD unless RSO has been selected in filter panel first?
I just search it is no way to make my first table show in Local currency immediately after I click on it.Sales Detail Report - Europe - Copy (2).pbix (3.9 MB)