Forum Discussion
Conditional column and DAX
I need some help with a conditional column and DAX; I have an expense report with 2 measures - 'Expenses Local' and 'Expenses USD'. I have created a single measure – ‘Expenses’ using a SWITCH on a d...
Hi MrDavidWilliams ,
Sorry for late reply. After researching, I think you could add another matrix to show the values of "Company" and "Currency". For more details, please see the PBIX below.
LocalUSD
I tried to find a workaround in the original matrix. But I failed. We only can add measures into Values field to implement dynamically filter.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.