Forum Discussion

drew989898's avatar
drew989898
Frequent Visitor
3 months ago
Solved

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

Hi,   I was wondering if anyone has had any success using the "New Visual Calculation (Preview)" feature yet on Calculated Groups? Particularly with Calculated Groups that have multiple items? With...
  • BeaBF's avatar
    BeaBF
    3 months ago

    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!

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
3 months ago

Thankyou, BeaBF and lbendlin for your responses.

Hi drew989898,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by BeaBF and lbendlin to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.