Forum Discussion
Using Visual Calculation on a Calculated Group with Multiple Calculated Items
drew989898 Hi!
I don’t think visual calculations currently support directly selecting a specific calculation item from a calculation group inside the visual calculation expression. The calc group column can be added to the visual, but the visual calculation only sees the resulting visual structure, not the individual calculation items as separate selectable objects.
The workaround I’d use is to create explicit wrapper measures with CALCULATE() that force the required calculation item, then use those measures in the visual calculation. That gives the visual calculation a normal measure/column to reference, while the calculation group logic still stays centralized.
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
drew989898 Hi!
I don’t think visual calculations currently support directly selecting a specific calculation item from a calculation group inside the visual calculation expression. The calc group column can be added to the visual, but the visual calculation only sees the resulting visual structure, not the individual calculation items as separate selectable objects.
The workaround I’d use is to create explicit wrapper measures with CALCULATE() that force the required calculation item, then use those measures in the visual calculation. That gives the visual calculation a normal measure/column to reference, while the calculation group logic still stays centralized.
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!