Forum Discussion
CALCULATED TABLE EXPRESSION AS OUTPUT OF A CONDITIONAL STATEMENT
Hi Michael_Gold ,
According to your description, we can't create a dynamic table or column changed by the parameter value, it's by design. Calculated table and column can only be computed during data refresh, it does not depend on user interaction in the report. You can refer to this blog for in-depth understanding.
However, we can create a dynamic measure based on the parameter value, I create a sample.
The measure dynamically varies with the parameter value.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
Community SupportHi Michael_Gold ,
According to your description, we can't create a dynamic table or column changed by the parameter value, it's by design. Calculated table and column can only be computed during data refresh, it does not depend on user interaction in the report. You can refer to this blog for in-depth understanding.
However, we can create a dynamic measure based on the parameter value, I create a sample.
The measure dynamically varies with the parameter value.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.