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...
Need Help
  • 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 USERELATIONSHIP, RELATED 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






Demert's avatar
Demert
Icon for Resolver III rankResolver III
1 year ago

Hi NandhiniNarasi ,

could you give more info about what you are trying to achieve. Currently when I look at the dax measure it's only 1 line of code which references 2 other measures where we don't know if those measures are optimized. All the other lines are commented out (//). If you visuals are loading slow, there can be many different factors to it. A lot of measures inside the visuals, many data to process, not optimized dax code....

  • NandhiniNarasi's avatar
    NandhiniNarasi
    New Member
    1 year ago

    Hi Thanks for your quick response. Actually i have a report and as you said its loading very slow and there are so much of DAX calculations in the report. Now my TL has asked me to convert it as a paginated report and add visual calcualtions in it, to improve the performance of the report. but im not sure how to do that.

    • v-nmadadi-msft's avatar
      v-nmadadi-msft
      Icon for Community Support rankCommunity Support
      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 USERELATIONSHIP, RELATED 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