Hi all, 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 i…

Hi @chiu2003 , Thanks for posting your file. You just need to change below measure. Due to filter from table’s row on ‘DIM-Customers’[Customer Description], it was always giving 1. So, after changing this base measure, your other measure is working perfectly fine. Num of Currency = CALCULATE(DIST…

How can I ignore the table context?

DAX DAX Calculations

Paul March 2, 2020, 3:45pm 4

Hi,

I suggest to watch the below video, Sam has published a few times about applying currency conversion.

Paul

1 Like