Forum Discussion
Conditional column and DAX
Thanks for letting me know that conditional columns are not dynamic. I don't think I can use a measure in this scenario because I already have 2 measures in the matrix - I would need to nest these 2 measures in the 'currency measure'. I don't think this is possible.
See example of matrix output below:
Matrix layout
Hi MrDavidWilliams ,
Can you please share a dummy file? I can't reproduce the matrix that you shared. I think maybe we can find a workaround using the .pbix file to implement your request.
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.
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.
Hi MrDavidWilliams ,
Can the workaround solve your problem? If it helps you, please accept the helpful replies as solutions. If not, please let me know.
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. Kudos are nice too.
Thanks for the workaround. It does work but it will not be accepted by the business user. It adds an additional column per company and repeats for every row. Unfortunately I cannot mark this as the solution.