Forum Discussion

NandhiniNarasi's avatar
NandhiniNarasi
New Member
1 year ago
Solved

Need to Convert Complex DAX into New visual calculation

I have a report which is done by an existing power bi developer and it takes much time to load the report. There are so much of complex DAX formulas which are there. I wanted to convert thse dax into...
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi NandhiniNarasi  ,
    Thanks for reaching out to the Microsoft fabric community forum.

    First select any visual of your choice from visual pane

     

     

    then Visual calculation will be available to use after selecting any visual of your choice ( not all visuals are supported for visual calculation)

     

     

     


    Using Custom visual calculation you can run any DAX of your choice.

    Please check this article to know more about visual calculation
    Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
    This will help you in converting DAX measures to Visual calculation

    Also make a note that  visual calculations work within the confines of the visual matrix, functions that rely on model relationships such as USERELATIONSHIPRELATED or RELATEDTABLE aren't available.

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thank you