Forum Discussion
Conditional column and DAX
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.
Hi MrDavidWilliams ,
Unfortunately, I didn't help you. I find two similar ideas about adding measures into the column field of matrix. You could vote it up to get it fixed quickly.
to be able to add measures on rows and columns at the same matrix
Allow the creater to use a measure as the column headings in a matrix
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.