Forum Discussion
Conditional column and DAX
Hi MrDavidWilliams ,
Calculated column is static. It is unavailable to filter data dynamically. Measures can implement show different values based on the context.
Can I ask you why you want to create a column rather than a measure? Do you want to create relationships between it and calendar table?
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.
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.