Forum Discussion
Dynamically Re-calculate Calculated Column (work-around?)
It takes some more advanced DAX but you can do this. You can create virtual tables with virtual columns in a measure; the columns can use those ranges in their calculation. The ranges can be harvested from an ROA table, or be calculated dynamically based on another measure (max value, etc.); I couldn't tell from your post which scenario you have. You can then do analysis on those virtual columns in that virtual table.
This blog shows an example - https://blog.enterprisedna.co/segment-your-customers-into-groups-advanced-dax-example/
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
It takes some more advanced DAX but you can do this. You can create virtual tables with virtual columns in a measure; the columns can use those ranges in their calculation. The ranges can be harvested from an ROA table, or be calculated dynamically based on another measure (max value, etc.); I couldn't tell from your post which scenario you have. You can then do analysis on those virtual columns in that virtual table.
This blog shows an example - https://blog.enterprisedna.co/segment-your-customers-into-groups-advanced-dax-example/
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thanks!